[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
810: /* CURSOR all_people_f_cursor_n IS
811: select paf.assignment_id ,
812: paf.effective_start_date
813: from per_people_f ppf ,
814: per_person_types ppt ,
815: per_people_extra_info ppei,
816: per_assignments_f paf
817: where ppf.person_type_id = ppt.person_type_id
818: and ppt.system_person_type in ('EMP' , 'EX_EMP')
864: ,ppe.process_event_id
865: ,ppe.object_version_number
866:
867: from per_people_f ppf
868: ,per_person_types ppt
869: ,per_people_extra_info pei
870: ,pay_process_events ppe
871: ,per_all_assignments_f paf
872:
913: paf.effective_start_date ,
914: ppe.process_event_id ,
915: ppe.object_version_number
916: from per_people_f ppf ,
917: per_person_types ppt ,
918: per_people_extra_info ppei,
919: pay_process_events ppe ,
920: per_assignments_f paf
921: where ppf.person_type_id = ppt.person_type_id
967: ,paf.effective_start_date
968:
969: from per_all_assignments_f paf
970: ,per_people_f ppf
971: ,per_person_types ppt
972:
973: where ppf.person_id = paf.person_id
974: and paf.assignment_type <> 'B' --RLN
975: and ppf.person_type_id = ppt.person_type_id
1013: select paf.assignment_id ,
1014: paf.effective_start_date
1015: from per_assignments_f paf ,
1016: per_people_f ppf ,
1017: per_person_types ppt ,
1018: (select * from per_people_extra_info
1019: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1020: and pei_information12 = 'WINDSTAR'
1021: and TO_CHAR(p_effective_date, 'YYYY') <=
1071: ,ppe.object_version_number
1072:
1073: from per_all_assignments_f paf
1074: ,per_people_f ppf
1075: ,per_person_types ppt
1076: ,pay_process_events ppe
1077:
1078: where ppf.person_id = paf.person_id
1079: and ppf.person_type_id = ppt.person_type_id
1121: ppe.object_version_number
1122:
1123: from per_assignments_f paf ,
1124: per_people_f ppf ,
1125: per_person_types ppt ,
1126: (select * from per_people_extra_info
1127: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1128: and pei_information12 = 'WINDSTAR'
1129: and TO_CHAR(p_effective_date, 'YYYY') <=
1622:
1623: from per_all_assignments_f paf
1624: ,per_people_f ppf
1625: ,pay_process_events ppe
1626: ,per_person_types ppt
1627: ,per_people_extra_info pei
1628:
1629: where ppf.person_id = paf.person_id
1630: and ppf.person_type_id = ppt.person_type_id
1678: ppf.person_id
1679: from per_assignments_f paf ,
1680: per_people_f ppf ,
1681: pay_process_events ppe ,
1682: per_person_types ppt ,
1683: per_people_extra_info ppei
1684: where ppf.person_id = paf.person_id
1685: and ppf.effective_start_date <= TO_DATE(('12/31/' ||
1686: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')
1735: ppf.suffix ,
1736: UPPER(ppf.marital_status) ,
1737: ppf.person_id
1738: from per_people_f ppf ,
1739: per_person_types ppt ,
1740: per_people_extra_info ppei
1741: where ppf.person_type_id = ppt.person_type_id
1742: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')
1743: and ppf.effective_start_date <=
1776: ppf.suffix ,
1777: UPPER(ppf.marital_status) ,
1778: ppf.person_id
1779: from per_people_f ppf ,
1780: per_person_types ppt ,
1781: (select * from per_people_extra_info
1782: where information_type = 'PER_US_ADDITIONAL_DETAILS'
1783: and pei_information12 = 'WINDSTAR'
1784: and TO_CHAR(p_effective_date, 'YYYY') <=
3391: --
3392: cursor c_terminated_employee_asg(p_person_id in number) is
3393: SELECT paf.effective_end_date
3394: FROM per_people_f ppf,
3395: per_person_types ppt,
3396: per_person_type_usages_f pptu,
3397: per_assignments_f paf
3398: WHERE ppf.person_id = 57504
3399: -- and ppf.person_type_id = ppt.person_type_id
4951: cursor c_person(p_person_id in number
4952: ,p_effective_date in date ) is
4953: select MAX(effective_end_date) effective_end_date
4954: from per_people_f ppf
4955: ,per_person_types ppt
4956: where ppf.person_id = p_person_id
4957: and ppf.person_type_id = ppt.person_type_id
4958: and ppt.system_person_type in ('EMP', 'EX_EMP') -- RLN 7039307
4959: and ppf.effective_start_date <=