DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 2624: ,per_periods_of_service pos

2620: CURSOR c_termination_check(p_assignment_id NUMBER)
2621: IS
2622: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2623: FROM per_all_assignments_f asg
2624: ,per_periods_of_service pos
2625: WHERE asg.person_id = pos.person_id
2626: AND asg.assignment_id = p_assignment_id
2627: AND asg.business_group_id = pos.business_group_id
2628: AND asg.business_group_id = g_bg_id