[Home] [Help]
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
773: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')
774: --
790: )
791: or
792: (paf.effective_end_date =
793: (select max(asx.effective_end_date)
794: from per_all_assignments_f asx
795: where asx.assignment_id = paf.assignment_id
796: and asx.effective_end_date between c_start_date
797: and c_end_date)
798: )
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:
872: where ppt.person_type_id = ppf.person_type_id
873: and ppt.business_group_id = ppf.business_group_id
874: and ppt.system_person_type in ('EMP', 'EX_EMP', 'EMP_APL')
895: )
896: or
897: (paf.effective_end_date =
898: (select max(asx.effective_end_date)
899: from per_all_assignments_f asx
900: where asx.assignment_id = paf.assignment_id
901: and asx.effective_end_date between c_start_date
902: and c_end_date)
903: )
963: ,c_effective_date in date) is
964: select paf.assignment_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
977: )
978: or
979: (paf.effective_end_date =
980: (select max(asx.effective_end_date)
981: from per_all_assignments_f asx
982: where asx.assignment_id = paf.assignment_id
983: and asx.effective_end_date between c_start_date
984: and c_end_date)
985: )
1066: ,paf.effective_start_date
1067: ,ppe.process_event_id
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:
1082: )
1083: or
1084: (paf.effective_end_date =
1085: (select max(asx.effective_end_date)
1086: from per_all_assignments_f asx
1087: where asx.assignment_id = paf.assignment_id
1088: and asx.business_group_id = paf.business_group_id
1089: and asx.person_id = paf.person_id
1090: and asx.effective_end_date between c_start_date
1402: NVL(hrlock.telephone_number_3 , ' ' ) telephone_number_3,
1403: NVL(hrlock.postal_code , ' ' ) postal_code
1404: from hr_locations hrlock,
1405: hr_soft_coding_keyflex hrsckf,
1406: per_all_assignments_f assign
1407: where p_effective_date between assign.effective_start_date
1408: and assign.effective_end_date
1409: and assign.assignment_id = p_per_assign_id
1410: and assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id
1615: ,ppf.suffix
1616: ,upper(ppf.marital_status)
1617: ,ppf.person_id
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
1641: )
1642: or
1643: (paf.effective_end_date =
1644: (select max(asx.effective_end_date)
1645: from per_all_assignments_f asx
1646: where asx.assignment_id = paf.assignment_id
1647: and asx.business_group_id = paf.business_group_id
1648: and asx.person_id = paf.person_id
1649: and asx.effective_end_date between c_year_start_date
3106: l_prev_year number ;
3107: l_count number := 0 ;
3108: l_counter number := 0 ;
3109: l_counter1 number := 0 ;
3110: l_temp_assignment_id per_all_assignments_f.assignment_id%type ;
3111: l_assignment_id per_all_assignments_f.assignment_id%type ;
3112: j number ;
3113: i number ;
3114: l_err_count number ;
3107: l_count number := 0 ;
3108: l_counter number := 0 ;
3109: l_counter1 number := 0 ;
3110: l_temp_assignment_id per_all_assignments_f.assignment_id%type ;
3111: l_assignment_id per_all_assignments_f.assignment_id%type ;
3112: j number ;
3113: i number ;
3114: l_err_count number ;
3115: l_person_id per_all_people_f.person_id%type ;
3182: ,c_year_start in date
3183: ,c_year_end in date ) is
3184: select distinct
3185: nvl(pet.element_information1, ' ') income_code
3186: from per_all_assignments_f paf
3187: ,per_all_people_f ppf
3188: ,pay_element_entries_f pee
3189: ,pay_element_links_f pel
3190: ,pay_element_types_f pet
3196: )
3197: or
3198: (paf.effective_end_date =
3199: (select max(asx.effective_end_date)
3200: from per_all_assignments_f asx
3201: where asx.assignment_id = paf.assignment_id
3202: and asx.business_group_id = paf.business_group_id
3203: and asx.person_id = paf.person_id
3204: and asx.effective_end_date between c_year_start
3313: ,hrlock.region_2) state
3314:
3315: from hr_locations hrlock
3316: ,hr_soft_coding_keyflex hrsckf
3317: ,per_all_assignments_f paf
3318:
3319: where paf.effective_start_date <=
3320: to_date(('12/31/'||to_char(p_effective_date,'YYYY')),'MM/DD/YYYY')
3321: and paf.effective_end_date >=
5001: pet.element_name element_name,
5002: pee.effective_start_date entry_start_date,
5003: nvl(pet.element_information1, ' ') element_income_code
5004:
5005: from per_all_assignments_f paf,
5006: per_all_people_f ppf,
5007: pay_element_entries_f pee,
5008: pay_element_links_f pel,
5009: pay_element_types_f pet,