[Home] [Help]
764: ,c_effective_date in date) is
765: select paf.assignment_id
766: ,paf.effective_start_date
767: from per_people_f ppf
768: ,per_person_types ppt
769: ,per_people_extra_info pei
770: ,per_all_assignments_f paf
771: where ppf.person_type_id = ppt.person_type_id
772: and ppf.business_group_id = ppt.business_group_id
809: /* CURSOR all_people_f_cursor_n IS
810: select paf.assignment_id ,
811: paf.effective_start_date
812: from per_people_f ppf ,
813: per_person_types ppt ,
814: per_people_extra_info ppei,
815: per_assignments_f paf
816: where ppf.person_type_id = ppt.person_type_id
817: and ppt.system_person_type in ('EMP' , 'EX_EMP')
863: ,ppe.process_event_id
864: ,ppe.object_version_number
865:
866: from per_people_f ppf
867: ,per_person_types ppt
868: ,per_people_extra_info pei
869: ,pay_process_events ppe
870: ,per_all_assignments_f paf
871:
911: paf.effective_start_date ,
912: ppe.process_event_id ,
913: ppe.object_version_number
914: from per_people_f ppf ,
915: per_person_types ppt ,
916: per_people_extra_info ppei,
917: pay_process_events ppe ,
918: per_assignments_f paf
919: where ppf.person_type_id = ppt.person_type_id
965: ,paf.effective_start_date
966:
967: from per_all_assignments_f paf
968: ,per_people_f ppf
969: ,per_person_types ppt
970:
971: where ppf.person_id = paf.person_id
972: and ppf.person_type_id = ppt.person_type_id
973: and ppf.national_identifier = c_national_indentifier
1010: select paf.assignment_id ,
1011: paf.effective_start_date
1012: from per_assignments_f paf ,
1013: per_people_f ppf ,
1014: per_person_types ppt ,
1015: (select * from per_people_extra_info
1016: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1017: and pei_information12 = 'WINDSTAR'
1018: and TO_CHAR(p_effective_date, 'YYYY') <=
1068: ,ppe.object_version_number
1069:
1070: from per_all_assignments_f paf
1071: ,per_people_f ppf
1072: ,per_person_types ppt
1073: ,pay_process_events ppe
1074:
1075: where ppf.person_id = paf.person_id
1076: and ppf.person_type_id = ppt.person_type_id
1117: ppe.object_version_number
1118:
1119: from per_assignments_f paf ,
1120: per_people_f ppf ,
1121: per_person_types ppt ,
1122: (select * from per_people_extra_info
1123: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1124: and pei_information12 = 'WINDSTAR'
1125: and TO_CHAR(p_effective_date, 'YYYY') <=
1618:
1619: from per_all_assignments_f paf
1620: ,per_people_f ppf
1621: ,pay_process_events ppe
1622: ,per_person_types ppt
1623: ,per_people_extra_info pei
1624:
1625: where ppf.person_id = paf.person_id
1626: and ppf.person_type_id = ppt.person_type_id
1674: ppf.person_id
1675: from per_assignments_f paf ,
1676: per_people_f ppf ,
1677: pay_process_events ppe ,
1678: per_person_types ppt ,
1679: per_people_extra_info ppei
1680: where ppf.person_id = paf.person_id
1681: and ppf.effective_start_date <= TO_DATE(('12/31/' ||
1682: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')
1731: ppf.suffix ,
1732: UPPER(ppf.marital_status) ,
1733: ppf.person_id
1734: from per_people_f ppf ,
1735: per_person_types ppt ,
1736: per_people_extra_info ppei
1737: where ppf.person_type_id = ppt.person_type_id
1738: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')
1739: and ppf.effective_start_date <=
1772: ppf.suffix ,
1773: UPPER(ppf.marital_status) ,
1774: ppf.person_id
1775: from per_people_f ppf ,
1776: per_person_types ppt ,
1777: (select * from per_people_extra_info
1778: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1779: and pei_information12 = 'WINDSTAR'
1780: and TO_CHAR(p_effective_date, 'YYYY') <=
3385: --
3386: cursor c_terminated_employee_asg(p_person_id in number) is
3387: select paf.effective_end_date
3388: from per_people_f ppf
3389: ,per_person_types ppt
3390: ,per_assignments_f paf
3391: where ppf.person_id = p_person_id
3392: and ppf.person_type_id = ppt.person_type_id
3393: and ppt.system_person_type ='EX_EMP'
4936: cursor c_person(p_person_id in number
4937: ,p_effective_date in date ) is
4938: select MAX(effective_end_date) effective_end_date
4939: from per_people_f ppf
4940: ,per_person_types ppt
4941: where ppf.person_id = p_person_id
4942: and ppf.person_type_id = ppt.person_type_id
4943: and ppt.system_person_type in ('EMP', 'EX_EMP') -- RLN 7039307
4944: and ppf.effective_start_date <=