DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 2454: per_periods_of_service POS

2450: from pay_action_classifications CLASS,
2451: pay_payroll_actions PACT,
2452: pay_assignment_actions ACT,
2453: per_all_assignments_f ASS,
2454: per_periods_of_service POS
2455: where POS.person_id = l_person_id
2456: and ASS.period_of_service_id = POS.period_of_service_id
2457: and ACT.assignment_id = ASS.assignment_id
2458: and ACT.action_sequence > l_action_sequence

Line 2472: per_periods_of_service POS

2468: from pay_action_classifications CLASS,
2469: pay_payroll_actions PACT,
2470: pay_assignment_actions ACT,
2471: per_all_assignments_f ASS,
2472: per_periods_of_service POS
2473: where POS.person_id = l_person_id
2474: and ASS.period_of_service_id = POS.period_of_service_id
2475: and ACT.assignment_id = ASS.assignment_id
2476: and ACT.action_sequence > l_action_sequence

Line 2785: from per_periods_of_service pos

2781: order by act.action_sequence desc;
2782: --
2783: cursor c3(c_period_of_service_id number) is
2784: select pos.period_of_service_id
2785: from per_periods_of_service pos
2786: where pos.period_of_service_id = c_period_of_service_id
2787: for update of pos.period_of_service_id;
2788: --
2789: commit_limit number;