DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ALL_PAYROLLS_F

Line 2787: from pay_all_payrolls_f PL

2783: ) is
2784: select PL.payroll_id
2785: ,PL.payroll_name
2786: ,PL.consolidation_set_id
2787: from pay_all_payrolls_f PL
2788: where p_payroll_id is not null
2789: and PL.business_group_id + 0 = p_business_group_id
2790: and PL.payroll_id = p_payroll_id
2791: and p_upload_date between PL.effective_start_date

Line 2797: from pay_all_payrolls_f PL

2793: union all
2794: select PL.payroll_id
2795: ,PL.payroll_name
2796: ,PL.consolidation_set_id
2797: from pay_all_payrolls_f PL
2798: where p_payroll_id is null
2799: and PL.business_group_id + 0 = p_business_group_id
2800: and upper(PL.payroll_name) = upper(p_payroll_name)
2801: and p_upload_date between PL.effective_start_date