APPS.HR_CONTINGENT_WORKER_API dependencies on PER_PERSON_TYPES

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

430: --
431:
432: l_proc varchar2(72) := g_package||'create_cwk';
433: l_person_id number;
434: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
435: l_person_type_id1 per_person_types.person_type_id%type;
436: l_start_date date;
437: l_date_of_birth date;
438: l_date_of_death date;

Line 435: l_person_type_id1 per_person_types.person_type_id%type;

431:
432: l_proc varchar2(72) := g_package||'create_cwk';
433: l_person_id number;
434: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
435: l_person_type_id1 per_person_types.person_type_id%type;
436: l_start_date date;
437: l_date_of_birth date;
438: l_date_of_death date;
439: l_receipt_of_death_cert_date date;

Line 1150: ,per_person_types ppt

1146: ,ppf.npw_number
1147: ,ppf.applicant_number
1148: ,ppf.employee_number
1149: FROM per_all_people_f ppf
1150: ,per_person_types ppt
1151: WHERE ppt.person_type_id = ppf.person_type_id
1152: AND ppf.person_id = p_person_id
1153: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
1154: --

Line 1165: ,per_person_types ppt

1161: SELECT ptu.person_type_id
1162: ,effective_start_date
1163: ,effective_end_date
1164: FROM per_person_type_usages_f ptu
1165: ,per_person_types ppt
1166: WHERE person_id = p_person_id
1167: AND effective_start_date > l_effective_date
1168: AND ptu.person_type_id = ppt.person_type_id
1169: AND ppt.system_person_type IN ('APL','EX_APL')

Line 1603: ,per_person_types ppt

1599: ,ppf.npw_number
1600: ,ppf.applicant_number
1601: ,ppf.employee_number
1602: FROM per_all_people_f ppf
1603: ,per_person_types ppt
1604: WHERE ppt.person_type_id = ppf.person_type_id
1605: AND ppf.person_id = p_person_id
1606: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
1607: --

Line 1619: ,per_person_types ppt

1615: select 'Y'
1616: from dual
1617: where exists (select 'Y'
1618: from per_person_type_usages_f ptu
1619: ,per_person_types ppt
1620: where ptu.person_id = p_person_id
1621: and ppt.person_type_id = ptu.person_type_id
1622: and ptu.effective_start_date >= p_effective_date
1623: and ppt.system_person_type = 'APL');

Line 2102: l_system_person_type1 per_person_types.system_person_type%TYPE;

2098: l_person_type_id number;
2099: l_proc varchar2(72)
2100: := g_package ||
2101: 'actual_termination_placement';
2102: l_system_person_type1 per_person_types.system_person_type%TYPE;
2103: l_per_effective_start_date date;
2104: l_datetrack_mode varchar2(30);
2105: l_validation_start_date date;
2106: l_validation_end_date date;

Line 2175: from per_person_type_usages_f ptu, per_person_types ppt

2171: -- ER FPT
2172: l_start_date date;
2173: cursor csr_fpt_ptu_changes is
2174: select null
2175: from per_person_type_usages_f ptu, per_person_types ppt
2176: where person_id = p_person_id
2177: and effective_start_date > l_actual_termination_date
2178: and ptu.person_type_id = ppt.person_type_id
2179: and ppt.system_person_type in ('EMP','CWK');

Line 3688: per_person_types pt

3684: --
3685: CURSOR future_person_types IS
3686: SELECT pt.system_person_type
3687: FROM per_person_type_usages_f ptu,
3688: per_person_types pt
3689: WHERE ptu.person_id = p_person_id
3690: AND ptu.person_type_id = pt.person_type_id
3691: AND ptu.effective_start_date > p_actual_termination_date;
3692:

Line 3741: from per_all_people_f per, per_person_types ppt

3737: -- ER FPT
3738: l_eff_start_date date;
3739: cursor get_min_eff_start_date is
3740: select min(effective_start_date)
3741: from per_all_people_f per, per_person_types ppt
3742: where per.person_id = p_person_id
3743: and effective_start_date > p_actual_termination_date
3744: and per.person_type_id = ppt.person_type_id
3745: and ppt.system_person_type in ('EX_APL','APL');