DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 2367: per_periods_of_service POS

2363: from pay_action_classifications CLASS,
2364: pay_payroll_actions PACT,
2365: pay_assignment_actions ACT,
2366: per_all_assignments_f ASS,
2367: per_periods_of_service POS
2368: where POS.person_id = l_person_id
2369: and ASS.period_of_service_id = POS.period_of_service_id
2370: and ACT.assignment_id = ASS.assignment_id
2371: and ACT.action_sequence > l_action_sequence

Line 2385: per_periods_of_service POS

2381: from pay_action_classifications CLASS,
2382: pay_payroll_actions PACT,
2383: pay_assignment_actions ACT,
2384: per_all_assignments_f ASS,
2385: per_periods_of_service POS
2386: where POS.person_id = l_person_id
2387: and ASS.period_of_service_id = POS.period_of_service_id
2388: and ACT.assignment_id = ASS.assignment_id
2389: and ACT.action_sequence > l_action_sequence

Line 2676: from per_periods_of_service pos

2672: order by act.action_sequence desc;
2673: --
2674: cursor c3(c_period_of_service_id number) is
2675: select pos.period_of_service_id
2676: from per_periods_of_service pos
2677: where pos.period_of_service_id = c_period_of_service_id
2678: for update of pos.period_of_service_id;
2679: --
2680: commit_limit number;