DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 2518: ,per_periods_of_service pos

2514: CURSOR c_termination_check(p_assignment_id NUMBER)
2515: IS
2516: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2517: FROM per_all_assignments_f asg
2518: ,per_periods_of_service pos
2519: WHERE asg.person_id = pos.person_id
2520: AND asg.assignment_id = p_assignment_id
2521: AND asg.business_group_id = pos.business_group_id
2522: AND asg.business_group_id = g_bg_id