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

Line 83: FROM per_person_types

79: -- Changed the cursor definition for bug 4756920.
80: --
81: CURSOR csr_ptu (p_person_type_id IN NUMBER, p_business_group_id IN NUMBER)
82: IS SELECT system_person_type
83: FROM per_person_types
84: WHERE business_group_id = p_business_group_id
85: AND person_type_id = p_person_type_id ;
86:
87: l_person_type per_person_types.system_person_type%TYPE;

Line 87: l_person_type per_person_types.system_person_type%TYPE;

83: FROM per_person_types
84: WHERE business_group_id = p_business_group_id
85: AND person_type_id = p_person_type_id ;
86:
87: l_person_type per_person_types.system_person_type%TYPE;
88:
89: BEGIN
90: --
91: IF hr_cn_employee_api.g_trace OR hr_cn_applicant_api.g_trace THEN