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 990: ,per_person_type_usages_f ptu

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

Line 1066: ,per_person_type_usages_f ptu

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

Line 1095: ,per_person_type_usages_f ptu

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

Line 2006: ,per_person_type_usages_f ptu

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