APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 3008: ,pay_all_payrolls_f ppf1

3004: ,pay_assignment_actions paa2
3005: ,pay_payroll_actions ppa2
3006: ,per_time_periods ptp1
3007: ,per_time_periods ptp2
3008: ,pay_all_payrolls_f ppf1
3009: ,pay_all_payrolls_f ppf2
3010: WHERE paa1.assignment_action_id = c_ass_act_id
3011: AND paa1.payroll_action_id = ppa1.payroll_action_id
3012: AND ppa1.payroll_id = ppf1.payroll_id

Line 3009: ,pay_all_payrolls_f ppf2

3005: ,pay_payroll_actions ppa2
3006: ,per_time_periods ptp1
3007: ,per_time_periods ptp2
3008: ,pay_all_payrolls_f ppf1
3009: ,pay_all_payrolls_f ppf2
3010: WHERE paa1.assignment_action_id = c_ass_act_id
3011: AND paa1.payroll_action_id = ppa1.payroll_action_id
3012: AND ppa1.payroll_id = ppf1.payroll_id
3013: AND ppa1.time_period_id = ptp1.time_period_id

Line 4298: ,pay_all_payrolls_f ppf

4294: ,c_paid_flag VARCHAR2) IS
4295: SELECT asl.assignment_id assignment_id
4296: ,paa.assignment_action_id assignment_action_id
4297: FROM per_all_assignments_f asl
4298: ,pay_all_payrolls_f ppf
4299: ,pay_payroll_actions ppa
4300: ,pay_assignment_actions paa
4301: ,per_time_periods ptp
4302: WHERE asl.person_id BETWEEN stperson AND endperson and

Line 4333: ,pay_all_payrolls_f ppf

4329: UNION
4330: SELECT asl.assignment_id assignment_id
4331: ,NULL assignment_action_id
4332: FROM per_all_assignments_f asl
4333: ,pay_all_payrolls_f ppf
4334: WHERE asl.person_id BETWEEN stperson AND endperson
4335: AND c_paid_flag = 'N'
4336: AND ppf.payroll_id = asl.payroll_id
4337: AND asl.assignment_type = 'E'

Line 4467: ,pay_all_payrolls_f ppf

4463: UNION
4464: SELECT asl.assignment_id assignment_id
4465: ,NULL assignment_action_id
4466: FROM per_all_assignments_f asl
4467: ,pay_all_payrolls_f ppf
4468: WHERE asl.person_id BETWEEN stperson AND endperson
4469: AND c_paid_flag = 'N'
4470: AND ppf.payroll_id = asl.payroll_id
4471: AND asl.assignment_type = 'E'