[Home] [Help]
436: select ppt.person_type_id
437: , pst.current_applicant_flag
438: , pst.current_emp_or_apl_flag
439: , pst.current_employee_flag
440: from per_person_types ppt
441: , per_startup_person_types pst
442: where ppt.business_group_id = p_business_group_id -- Bug fix 3645987
443: and pst.system_person_type = ppt.system_person_type
444: and ppt.active_flag = 'Y'
740: select ppt.person_type_id
741: , pst.current_applicant_flag
742: , pst.current_emp_or_apl_flag
743: , pst.current_employee_flag
744: from per_person_types ppt
745: , per_startup_person_types pst
746: where ppt.business_group_id = X_business_group_id --bug fix 3645987
747: and pst.system_person_type = ppt.system_person_type
748: and ppt.active_flag = 'Y'
1847: , pst.current_employee_flag
1848: , pst.current_applicant_flag
1849: , pst.current_emp_or_apl_flag
1850: , to_date('31/12/4712','DD/MM/YYYY') effective_end_date
1851: from per_person_types ppt
1852: , per_startup_person_types pst
1853: where ppt.business_group_id =X_Business_group_id --Bug fix 3645987
1854: and ppt.system_person_type = pst.system_person_type
1855: and ppt.system_person_type = 'EMP'
2326: cursor fpt_future_exists
2327: IS
2328: select 'Y'
2329: from per_person_type_usages_f ptu
2330: ,per_person_types ppt
2331: ,per_all_people_f per
2332: where per.person_id = p_person_id
2333: and per.person_id = ptu.person_id
2334: and per.business_group_id = p_business_group_id
2340: cursor future_exists
2341: IS
2342: select 'Y'
2343: from per_people_f ppf
2344: ,per_person_types ppt
2345: ,per_startup_person_types pst
2346: where ppf.person_type_id = ppt.person_type_id
2347: and ppf.person_id = p_person_id
2348: and ppf.business_group_id +0 = ppt.business_group_id+0