APPS.PAY_PAYACT_PKG dependencies on PAY_PAYROLLS_F

Line 226: -- to include pay_payrolls_f and inputs from

222: where ppa.payroll_action_id = pactid;
223:
224:
225: -- Bug 3372732 : All cursors defined below are changed
226: -- to include pay_payrolls_f and inputs from
227: -- cursor c_inputs .
228:
229: CURSOR c_bal_adj
230: (

Line 250: pay_payrolls_f ppf -- Bug 3372732

246: from pay_assignment_actions act,
247: per_assignments_f paf,
248: pay_payroll_actions ppa, /* pre-payments and reversals
249: payroll action id */
250: pay_payrolls_f ppf -- Bug 3372732
251: where ppa.payroll_id = nvl(c_payroll_id,ppa.payroll_id)
252: and ppa.consolidation_set_id + 0 = nvl(c_consolidation_set_id,
253: ppa.consolidation_set_id)
254: and ppa.effective_date between c_start_date

Line 305: pay_payrolls_f ppf -- Bug 3372732

301: act.tax_unit_id
302: from pay_assignment_actions act,
303: per_assignments_f paf,
304: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
305: pay_payrolls_f ppf -- Bug 3372732
306: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
307: and ppa.consolidation_set_id +0 =
308: nvl(c_consolidation_set_id, ppa.consolidation_set_id)
309: and ppa.effective_date between c_start_date and c_effective_date

Line 360: pay_payrolls_f ppf -- Bug 3372732

356: act.tax_unit_id
357: from pay_assignment_actions act,
358: per_assignments_f paf,
359: pay_payroll_actions ppa, /* pre-payments and reversals payroll action id */
360: pay_payrolls_f ppf -- Bug 3372732
361: where ppa.payroll_id =
362: nvl(c_payroll_id, ppa.payroll_id)
363: and ppa.consolidation_set_id +0 =
364: nvl(c_consolidation_set_id, ppa.consolidation_set_id)

Line 416: pay_payrolls_f ppf -- Bug 3372732

412: from pay_assignment_actions act,
413: per_assignments_f paf,
414: pay_payroll_actions ppa, /* pre-payments and reversals */
415: /* payroll action id */
416: pay_payrolls_f ppf -- Bug 3372732
417: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
418: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
419: ppa.consolidation_set_id)
420: and ppa.effective_date between c_start_date and c_effective_date

Line 471: pay_payrolls_f ppf -- Bug 3372732

467: from pay_assignment_actions act,
468: per_assignments_f paf,
469: pay_payroll_actions ppa, /* pre-payments and */
470: /* reversals payroll action id */
471: pay_payrolls_f ppf -- Bug 3372732
472: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
473: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
474: ppa.consolidation_set_id)
475: and ppa.effective_date between c_start_date and c_effective_date

Line 526: pay_payrolls_f ppf

522: from pay_assignment_actions act,
523: per_assignments_f paf,
524: pay_payroll_actions ppa, /* pre-payments and */
525: /* reversals payroll action id */
526: pay_payrolls_f ppf
527: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
528: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
529: ppa.consolidation_set_id)
530: and ppa.effective_date between c_start_date and c_effective_date

Line 580: pay_payrolls_f ppf -- Bug 3372732

576: from pay_assignment_actions act,
577: per_assignments_f paf,
578: pay_payroll_actions ppa, /* pre-payments and */
579: /* reversals payroll action id */
580: pay_payrolls_f ppf -- Bug 3372732
581: where ppa.payroll_id =
582: nvl(c_payroll_id, ppa.payroll_id)
583: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
584: ppa.consolidation_set_id)

Line 635: pay_payrolls_f ppf

631: from pay_assignment_actions act,
632: per_assignments_f paf,
633: pay_payroll_actions ppa, /* pre-payments and */
634: /* reversals payroll action id */
635: pay_payrolls_f ppf
636: where ppa.payroll_id = nvl(c_payroll_id, ppa.payroll_id)
637: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id ,ppa.consolidation_set_id)
638: and ppa.effective_date between c_start_date and c_effective_date
639: and act.tax_unit_id = nvl(c_tax_unit_id,act.tax_unit_id)