eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_GB_DISABILITY dependencies on PER_ALL_PEOPLE_F

Line 13: from per_all_people_f ppf

9:
10: cursor csr_get_securityid
11: is
12: select distinct security_group_id
13: from per_all_people_f ppf
14: ,per_business_groups pbg
15: where ppf.person_id = p_person_id
16: and ppf.business_group_id= pbg.business_group_id
17: and p_effective_date between

Line 79: ,per_all_people_f ppf

75: cursor csr_get_securityid
76: is
77: select distinct security_group_id
78: from per_disabilities_f pdf
79: ,per_all_people_f ppf
80: ,per_business_groups pbg
81: where ppf.person_id = pdf.person_id
82: and ppf.business_group_id= pbg.business_group_id
83: and pdf.disability_id = p_disability_id