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_APPLICANT_PKG dependencies on PER_PERSON_TYPES

Line 369: from per_person_types

365: -- cursor c1 modified - '+0' removed to improve performance.
366:
367: cursor c1 is
368: select person_type_id
369: from per_person_types
370: where business_group_id = p_business_group_id
371: and system_person_type = 'EX_APL'
372: and active_flag = 'Y'
373: and default_flag = 'Y' ;

Line 1332: from per_person_types

1328:
1329: cursor c1 is
1330: select person_type_id,
1331: system_person_type
1332: from per_person_types
1333: where business_group_id = p_business_group_id
1334: and system_person_type = 'APL'
1335: and active_flag = 'Y'
1336: and default_flag = 'Y' ;

Line 2149: per_person_types ppt

2145: --
2146: cursor c2 is
2147: select ppt.system_person_type
2148: from per_people_f per,
2149: per_person_types ppt
2150: where per.person_id = p_person_id
2151: and per.person_type_id = ppt.person_type_id ;
2152: begin
2153: --