APPS.PER_HRTCA_MERGE dependencies on PER_PERSON_TYPES

Line 989: FROM per_person_types typ

985: ,p_person_id IN NUMBER
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

Line 1048: -- l_system_person_type per_person_types.system_person_type%type;

1044: RETURN VARCHAR2
1045: is
1046: --
1047: -- Bug fix 3260686. l_sytem_person_type changed to varchar2(2000).
1048: -- l_system_person_type per_person_types.system_person_type%type;
1049: l_system_person_type varchar2(2000);
1050: --
1051: l_effective_date date := hr_api.g_eot;
1052: l_return_value varchar2(30);

Line 1065: ,per_person_types typ

1061: )
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

Line 1094: ,per_person_types typ

1090: )
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

Line 2005: ,per_person_types typ

2001: )
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