[Home] [Help]
611: --***********************************************************************/
612: IS
613: --
614: CURSOR lcu_emp_assignment_det_r(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
615: ,p_business_group_id per_assignments_f.business_group_id%TYPE
616: ,p_effective_date DATE
617: ,p_payroll_id pay_payrolls_f.payroll_id%TYPE
618: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE
619: ,p_termination_date_from DATE
621: )
622: IS
623: SELECT PAF.assignment_id
624: ,PPS.actual_termination_date
625: FROM per_assignments_f PAF
626: ,per_people_f PPF
627: ,per_periods_of_service PPS
628: ,pay_population_ranges PPR
629: ,pay_payroll_actions PPA
669: --
670: CURSOR lcu_emp_assignment_det ( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
671: ,p_start_person_id per_all_people_f.person_id%TYPE
672: ,p_end_person_id per_all_people_f.person_id%TYPE
673: ,p_business_group_id per_assignments_f.business_group_id%TYPE
674: ,p_effective_date DATE
675: ,p_payroll_id pay_payrolls_f.payroll_id%TYPE
676: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE
677: ,p_termination_date_from DATE
679: )
680: IS
681: SELECT PAF.assignment_id
682: ,PPS.actual_termination_date
683: FROM per_assignments_f PAF
684: ,per_people_f PPF
685: ,per_periods_of_service PPS
686: WHERE PAF.person_id = PPF.person_id
687: AND PPF.person_id = PPS.person_id
961: ,DECODE(PADR.address_id,NULL,PADC.address_line1 ,PADR.address_line1) address_line1
962: ,DECODE(PADR.address_id,NULL,PADC.address_line2 ,PADR.address_line2) address_line2
963: ,DECODE(PADR.address_id,NULL,PADC.address_line3 ,PADR.address_line3) address_line3
964: FROM per_people_f PPF
965: , per_assignments_f PAF
966: , per_periods_of_service PPS
967: , per_addresses PADR
968: , per_addresses PADC
969: WHERE PAF.person_id = PPF.person_id