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_HRTCA_MERGE dependencies on PER_PERSON_TYPE_USAGES_F

Line 987: ,per_person_type_usages_f ptu

983: )
984: IS
985: SELECT typ.system_person_type
986: FROM per_person_types typ
987: ,per_person_type_usages_f ptu
988: WHERE typ.person_type_id = ptu.person_type_id
989: --AND typ.system_person_type IN ('APL','EMP','EX_APL','EX_EMP','CWK','EX_CWK','OTHER')
990: AND p_effective_date BETWEEN ptu.effective_start_date
991: AND ptu.effective_end_date

Line 1063: ,per_person_type_usages_f ptu

1059: IS
1060: SELECT typ.system_person_type
1061: FROM per_all_people_f ppf
1062: ,per_person_types typ
1063: ,per_person_type_usages_f ptu
1064: WHERE ppf.party_id = p_party_id
1065: AND ppf.effective_end_date = p_effective_date
1066: AND ppf.person_id = ptu.person_id
1067: AND typ.person_type_id = ptu.person_type_id

Line 1092: ,per_person_type_usages_f ptu

1088: IS
1089: SELECT typ.system_person_type
1090: FROM per_all_people_f ppf
1091: ,per_person_types typ
1092: ,per_person_type_usages_f ptu
1093: WHERE ppf.person_id = p_person_id
1094: AND ppf.effective_end_date = p_effective_date
1095: AND ppf.person_id = ptu.person_id
1096: AND typ.person_type_id = ptu.person_type_id

Line 2003: ,per_person_type_usages_f ptu

1999: IS
2000: SELECT typ.system_person_type
2001: FROM per_all_people_f ppf
2002: ,per_person_types typ
2003: ,per_person_type_usages_f ptu
2004: WHERE ppf.party_id = p_party_id
2005: AND ppf.effective_end_date = p_effective_date
2006: AND ppf.person_id = ptu.person_id
2007: AND typ.person_type_id = ptu.person_type_id