APPS.PEPTOEXC dependencies on PAY_PAYROLL_ACTIONS

Line 184: pay_payroll_actions bact,

180: )/12) *12) finyear
181: into l_accrual_year_end
182: from per_periods_of_service pps,
183: per_all_assignments_f asg,
184: pay_payroll_actions bact,
185: pay_assignment_actions bal_assact
186: where bact.payroll_action_id = p_owner_payroll_action_id
187: and bal_assact.payroll_action_id = bact.payroll_action_id
188: and pps.period_of_service_id = asg.period_of_service_id

Line 231: pay_payroll_actions bact,

227: )/12) *12) finyear
228: into l_accrual_year_end
229: from per_periods_of_service pps,
230: per_all_assignments_f asg,
231: pay_payroll_actions bact,
232: pay_assignment_actions bal_assact
233: where bact.payroll_action_id = p_owner_payroll_action_id
234: and bal_assact.payroll_action_id = bact.payroll_action_id
235: and pps.period_of_service_id = asg.period_of_service_id

Line 278: from pay_payroll_actions

274: ) is
275:
276: cursor c_date_earned(p_payroll_action_id number) is
277: select date_earned
278: from pay_payroll_actions
279: where payroll_action_id = p_payroll_action_id;
280:
281: l_expiry_date date;
282: l_curr_expiry_date date;

Line 336: from pay_payroll_actions

332: ) is
333:
334: cursor c_date_earned(p_payroll_action_id number) is
335: select date_earned
336: from pay_payroll_actions
337: where payroll_action_id = p_payroll_action_id;
338:
339: l_expiry_date date;
340: l_owner_date_earned date;

Line 379: from pay_payroll_actions

375: ) is
376:
377: cursor c_date_earned(p_payroll_action_id number) is
378: select date_earned
379: from pay_payroll_actions
380: where payroll_action_id = p_payroll_action_id;
381:
382: l_expiry_date date;
383: l_curr_expiry_date date;

Line 450: from pay_payroll_actions

446: ) is
447:
448: cursor c_date_earned(p_payroll_action_id number) is
449: select date_earned
450: from pay_payroll_actions
451: where payroll_action_id = p_payroll_action_id;
452:
453: l_expiry_date date;
454: l_owner_date_earned date;

Line 502: from pay_payroll_actions

498: ) is
499:
500: cursor c_date_earned(p_payroll_action_id number) is
501: select date_earned
502: from pay_payroll_actions
503: where payroll_action_id = p_payroll_action_id;
504:
505: l_expiry_date date;
506: l_curr_expiry_date date;

Line 528: pay_payroll_actions bact,

524: )/12) *12) finyear
525: into l_expiry_date
526: from per_periods_of_service pps,
527: per_all_assignments_f asg,
528: pay_payroll_actions bact,
529: pay_assignment_actions bal_assact
530: where bact.payroll_action_id = p_owner_payroll_action_id
531: and bal_assact.payroll_action_id = bact.payroll_action_id
532: and pps.period_of_service_id = asg.period_of_service_id

Line 580: from pay_payroll_actions

576: ) is
577:
578: cursor c_date_earned(p_payroll_action_id number) is
579: select date_earned
580: from pay_payroll_actions
581: where payroll_action_id = p_payroll_action_id;
582:
583: l_expiry_date date;
584:

Line 594: pay_payroll_actions bact,

590: )/12) *12) finyear
591: into l_expiry_date
592: from per_periods_of_service pps,
593: per_all_assignments_f asg,
594: pay_payroll_actions bact,
595: pay_assignment_actions bal_assact
596: where bact.payroll_action_id = p_owner_payroll_action_id
597: and bal_assact.payroll_action_id = bact.payroll_action_id
598: and pps.period_of_service_id = asg.period_of_service_id