DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on PAY_ALL_PAYROLLS_F

Line 1345: from pay_all_payrolls_f pa

1341: select pa.payroll_id,
1342: max(pa.effective_end_date)
1343: into v_payroll_id,
1344: v_payroll_end_date
1345: from pay_all_payrolls_f pa
1346: where upper(pa.payroll_name) = upper(p_payroll_name)
1347: and pa.business_group_id + 0 = v_business_group_id
1348: and pa.effective_start_date <= v_effective_end_date
1349: and pa.effective_end_date >= v_effective_start_date