APPS.PAY_AU_PAYE_FF dependencies on PAY_PAYROLLS_F

Line 800: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,

796: Legal Employer start date) and current period end date*/
797:
798: cursor c_get_periods
799: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
800: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
801: c_start_date in date,
802: c_end_date in date)
803: is
804: select count(DISTINCT ptp.time_period_id)

Line 824: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,

820: /* bug 12753997 - New c_get_periods_1n3 and c_get_periods_2 cursors are added to be based on regular payment date */
821:
822: cursor c_get_periods_1n3
823: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
824: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
825: c_start_date in date,
826: c_end_date in date)
827: is
828: select count(DISTINCT ptp.time_period_id)

Line 845: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,

841: AND ptp.regular_payment_date BETWEEN c_start_date AND c_end_date; -- bug12753997
842:
843: cursor c_get_periods_2
844: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
845: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
846: c_start_date in date,
847: c_end_date in date)
848: is
849: select count(DISTINCT ptp.time_period_id)