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.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_PERSON_TYPES

Line 832: FROM per_person_types

828: RETURN varchar2 IS
829:
830: CURSOR csr_sys_person_type IS
831: SELECT system_person_type
832: FROM per_person_types
833: WHERE person_type_id = p_person_type_id;
834:
835: l_sys_person_type varchar2(2000);
836:

Line 864: FROM per_person_types

860:
861:
862: CURSOR csr_all_emp_person_type_id(p_business_group_id in number) IS
863: SELECT person_type_id
864: FROM per_person_types
865: WHERE (system_person_type = 'EMP' )
866: AND business_group_id = p_business_group_id;
867:
868: CURSOR csr_all_apl_person_type_id(p_business_group_id in number) IS

Line 870: FROM per_person_types

866: AND business_group_id = p_business_group_id;
867:
868: CURSOR csr_all_apl_person_type_id(p_business_group_id in number) IS
869: SELECT person_type_id
870: FROM per_person_types
871: WHERE system_person_type = 'APL'
872: AND business_group_id = p_business_group_id;
873:
874: