APPS.PAY_PAYACT_PKG dependencies on PAY_PAYROLLS_F

Line 223: -- to include pay_payrolls_f and inputs from

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

Line 247: pay_payrolls_f ppf -- Bug 3372732

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

Line 302: pay_payrolls_f ppf -- Bug 3372732

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

Line 357: pay_payrolls_f ppf -- Bug 3372732

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

Line 413: pay_payrolls_f ppf -- Bug 3372732

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

Line 468: pay_payrolls_f ppf -- Bug 3372732

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

Line 523: pay_payrolls_f ppf

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

Line 577: pay_payrolls_f ppf -- Bug 3372732

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

Line 632: pay_payrolls_f ppf

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