DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on PER_ALL_ASSIGNMENTS_F

Line 871: from per_all_assignments_f paaf

867: cursor c_all_asg_ids(p_payroll_id number,
868: p_effective_date date) is
869: select assignment_id,
870: assignment_number
871: from per_all_assignments_f paaf
872: where payroll_id = p_payroll_id
873: and assignment_status_type_id in (1,3) -- pick active and terminated ( whose final process date is left) assignments
874: and p_effective_date between effective_start_date and effective_end_date ;
875: