APPS.PER_HRTCA_MERGE dependencies on PER_PERSON_TYPES

Line 986: FROM per_person_types typ

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

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

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

Line 1062: ,per_person_types typ

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

Line 1091: ,per_person_types typ

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

Line 2002: ,per_person_types typ

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