APPS.HR_CONTINGENT_WORKER_API dependencies on PER_PERSON_TYPES

Line 151: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;

147: --
148:
149: l_proc varchar2(72) := g_package||'create_cwk';
150: l_person_id number;
151: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
152: l_person_type_id1 per_person_types.person_type_id%type;
153: l_start_date date;
154: l_date_of_birth date;
155: l_date_of_death date;

Line 152: l_person_type_id1 per_person_types.person_type_id%type;

148:
149: l_proc varchar2(72) := g_package||'create_cwk';
150: l_person_id number;
151: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
152: l_person_type_id1 per_person_types.person_type_id%type;
153: l_start_date date;
154: l_date_of_birth date;
155: l_date_of_death date;
156: l_receipt_of_death_cert_date date;

Line 862: ,per_person_types ppt

858: ,ppf.npw_number
859: ,ppf.applicant_number
860: ,ppf.employee_number
861: FROM per_all_people_f ppf
862: ,per_person_types ppt
863: WHERE ppt.person_type_id = ppf.person_type_id
864: AND ppf.person_id = p_person_id
865: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
866: --

Line 1237: ,per_person_types ppt

1233: ,ppf.npw_number
1234: ,ppf.applicant_number
1235: ,ppf.employee_number
1236: FROM per_all_people_f ppf
1237: ,per_person_types ppt
1238: WHERE ppt.person_type_id = ppf.person_type_id
1239: AND ppf.person_id = p_person_id
1240: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
1241: --

Line 1253: ,per_person_types ppt

1249: select 'Y'
1250: from dual
1251: where exists (select 'Y'
1252: from per_person_type_usages_f ptu
1253: ,per_person_types ppt
1254: where ptu.person_id = p_person_id
1255: and ppt.person_type_id = ptu.person_type_id
1256: and ptu.effective_start_date >= p_effective_date
1257: and ppt.system_person_type = 'APL');

Line 1729: l_system_person_type1 per_person_types.system_person_type%TYPE;

1725: l_person_type_id number;
1726: l_proc varchar2(72)
1727: := g_package ||
1728: 'actual_termination_placement';
1729: l_system_person_type1 per_person_types.system_person_type%TYPE;
1730: l_per_effective_start_date date;
1731: l_datetrack_mode varchar2(30);
1732: l_validation_start_date date;
1733: l_validation_end_date date;

Line 3266: per_person_types pt

3262: --
3263: CURSOR future_person_types IS
3264: SELECT pt.system_person_type
3265: FROM per_person_type_usages_f ptu,
3266: per_person_types pt
3267: WHERE ptu.person_id = p_person_id
3268: AND ptu.person_type_id = pt.person_type_id
3269: AND ptu.effective_start_date > p_actual_termination_date;
3270: