DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_ALL_PAYROLLS_F

Line 3080: from pay_all_payrolls_f PL

3076: ) is
3077: select PL.payroll_id
3078: ,PL.payroll_name
3079: ,PL.consolidation_set_id
3080: from pay_all_payrolls_f PL
3081: where p_payroll_id is not null
3082: and PL.business_group_id + 0 = p_business_group_id
3083: and PL.payroll_id = p_payroll_id
3084: and p_upload_date between PL.effective_start_date

Line 3090: from pay_all_payrolls_f PL

3086: union all
3087: select PL.payroll_id
3088: ,PL.payroll_name
3089: ,PL.consolidation_set_id
3090: from pay_all_payrolls_f PL
3091: where p_payroll_id is null
3092: and PL.business_group_id + 0 = p_business_group_id
3093: and upper(PL.payroll_name) = upper(p_payroll_name)
3094: and p_upload_date between PL.effective_start_date