1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Dependent package list of per_all_people_f table

Discussion in 'Oracle HRMS & Payroll' started by katripon, Feb 11, 2010.

  1. katripon

    katripon Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,
    How can I know which packages are using per_all_people_f table in ERP?
    Can anybody help by providing me query/script?

    Thanks
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    You need to use the view DBA_DEPENDENCIES to find out which all objects are using the table. You can also filter your query by object TYPE to find only packages.
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi
    katripon,

    There is another way like below.

    SELECT distinct name FROM user_source where type='PACKAGE'
    and upper(text) like '%PER%PEOPLE%F%'

    Hope this will help you...
     
  4. sivaramakrishna.d

    sivaramakrishna.d Active Member

    Messages:
    61
    Likes Received:
    6
    Trophy Points:
    160
    Hi,

    If you are having Toad. You can see the dependencies of "Per_all_people_f" by selecting the table.

    else

    select name from user_source where type = 'PACKAGE' and text like '%per_all_people_f%

    Siva Ram