DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 252: ,per_periods_of_service pos

248: CURSOR c_termination_check
249: IS
250: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
251: FROM per_all_assignments_f asg
252: ,per_periods_of_service pos
253: WHERE asg.person_id = pos.person_id
254: AND asg.assignment_id = p_assignment_id
255: AND asg.business_group_id = pos.business_group_id
256: AND asg.business_group_id = g_bg_id

Line 2726: ,per_periods_of_service pos

2722: CURSOR c_termination_check(p_assignment_id NUMBER)
2723: IS
2724: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2725: FROM per_all_assignments_f asg
2726: ,per_periods_of_service pos
2727: WHERE asg.person_id = pos.person_id
2728: AND asg.assignment_id = p_assignment_id
2729: AND asg.business_group_id = pos.business_group_id
2730: AND asg.business_group_id = g_bg_id