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 401: from per_person_types

397: -- cursor c1 modified - '+0' removed to improve performance.
398:
399: cursor c1 is
400: select person_type_id
401: from per_person_types
402: where business_group_id = p_business_group_id
403: and system_person_type = 'EX_APL'
404: and active_flag = 'Y'
405: and default_flag = 'Y' ;

Line 1456: from per_person_types

1452:
1453: cursor c1 is
1454: select person_type_id,
1455: system_person_type
1456: from per_person_types
1457: where business_group_id = p_business_group_id
1458: and system_person_type = 'APL'
1459: and active_flag = 'Y'
1460: and default_flag = 'Y' ;

Line 2586: per_person_types ppt

2582: --
2583: cursor c2 is
2584: select ppt.system_person_type
2585: from per_people_f per,
2586: per_person_types ppt
2587: where per.person_id = p_person_id
2588: and per.person_type_id = ppt.person_type_id ;
2589: begin
2590: --