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_IN_PERSON_LEG_HOOK dependencies on PER_PEOPLE_F

Line 367: SELECT 1 FROM per_people_f

363: AND ORG_INFORMATION_CONTEXT = 'PER_IN_STAT_SETUP_DF';
364:
365: CURSOR csr_number
366: IS
367: SELECT 1 FROM per_people_f
368: WHERE business_group_id = p_business_group_id
369: AND per_information_category = 'IN'
370: AND (person_id <> p_person_id OR p_person_id is null)
371: AND decode(p_field,'PAN',per_information4

Line 1468: FROM per_people_f

1464: ,per_information13
1465: ,per_information14
1466: ,per_information15
1467: ,business_group_id
1468: FROM per_people_f
1469: WHERE p_effective_date BETWEEN effective_start_date
1470: AND effective_end_date
1471: AND person_id = p_person_id;
1472: