[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: --
791: )
792: or
793: (paf.effective_end_date =
794: (select max(asx.effective_end_date)
795: from per_all_assignments_f asx
796: where asx.assignment_id = paf.assignment_id
797: and asx.effective_end_date between c_start_date
798: and c_end_date)
799: )
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:
873: where ppt.person_type_id = ppf.person_type_id
874: and paf.assignment_type <> 'B' --RLN
875: and ppt.business_group_id = ppf.business_group_id
897: )
898: or
899: (paf.effective_end_date =
900: (select max(asx.effective_end_date)
901: from per_all_assignments_f asx
902: where asx.assignment_id = paf.assignment_id
903: and asx.effective_end_date between c_start_date
904: and c_end_date)
905: )
965: ,c_effective_date in date) is
966: select paf.assignment_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
980: )
981: or
982: (paf.effective_end_date =
983: (select max(asx.effective_end_date)
984: from per_all_assignments_f asx
985: where asx.assignment_id = paf.assignment_id
986: and asx.effective_end_date between c_start_date
987: and c_end_date)
988: )
1069: ,paf.effective_start_date
1070: ,ppe.process_event_id
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:
1086: )
1087: or
1088: (paf.effective_end_date =
1089: (select max(asx.effective_end_date)
1090: from per_all_assignments_f asx
1091: where asx.assignment_id = paf.assignment_id
1092: and asx.business_group_id = paf.business_group_id
1093: and asx.person_id = paf.person_id
1094: and asx.effective_end_date between c_start_date
1406: NVL(hrlock.telephone_number_3 , ' ' ) telephone_number_3,
1407: NVL(hrlock.postal_code , ' ' ) postal_code
1408: from hr_locations hrlock,
1409: hr_soft_coding_keyflex hrsckf,
1410: per_all_assignments_f assign
1411: where p_effective_date between assign.effective_start_date
1412: and assign.effective_end_date
1413: and assign.assignment_id = p_per_assign_id
1414: and assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id
1619: ,ppf.suffix
1620: ,upper(ppf.marital_status)
1621: ,ppf.person_id
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
1645: )
1646: or
1647: (paf.effective_end_date =
1648: (select max(asx.effective_end_date)
1649: from per_all_assignments_f asx
1650: where asx.assignment_id = paf.assignment_id
1651: and asx.business_group_id = paf.business_group_id
1652: and asx.person_id = paf.person_id
1653: and asx.effective_end_date between c_year_start_date
3110: l_prev_year number ;
3111: l_count number := 0 ;
3112: l_counter number := 0 ;
3113: l_counter1 number := 0 ;
3114: l_temp_assignment_id per_all_assignments_f.assignment_id%type ;
3115: l_assignment_id per_all_assignments_f.assignment_id%type ;
3116: j number ;
3117: i number ;
3118: l_err_count number ;
3111: l_count number := 0 ;
3112: l_counter number := 0 ;
3113: l_counter1 number := 0 ;
3114: l_temp_assignment_id per_all_assignments_f.assignment_id%type ;
3115: l_assignment_id per_all_assignments_f.assignment_id%type ;
3116: j number ;
3117: i number ;
3118: l_err_count number ;
3119: l_person_id per_all_people_f.person_id%type ;
3186: ,c_year_start in date
3187: ,c_year_end in date ) is
3188: select distinct
3189: nvl(pet.element_information1, ' ') income_code
3190: from per_all_assignments_f paf
3191: ,per_all_people_f ppf
3192: ,pay_element_entries_f pee
3193: ,pay_element_links_f pel
3194: ,pay_element_types_f pet
3200: )
3201: or
3202: (paf.effective_end_date =
3203: (select max(asx.effective_end_date)
3204: from per_all_assignments_f asx
3205: where asx.assignment_id = paf.assignment_id
3206: and asx.business_group_id = paf.business_group_id
3207: and asx.person_id = paf.person_id
3208: and asx.effective_end_date between c_year_start
3319: ,hrlock.region_2) state
3320:
3321: from hr_locations hrlock
3322: ,hr_soft_coding_keyflex hrsckf
3323: ,per_all_assignments_f paf
3324:
3325: where paf.effective_start_date <=
3326: to_date(('12/31/'||to_char(p_effective_date,'YYYY')),'MM/DD/YYYY')
3327: and paf.effective_end_date >=
5016: pet.element_name element_name,
5017: pee.effective_start_date entry_start_date,
5018: nvl(pet.element_information1, ' ') element_income_code
5019:
5020: from per_all_assignments_f paf,
5021: per_all_people_f ppf,
5022: pay_element_entries_f pee,
5023: pay_element_links_f pel,
5024: pay_element_types_f pet,