DBA Data[Home] [Help]

APPS.PAY_FR_DB_PAY_SETUP dependencies on PAY_ALL_PAYROLLS_F

Line 1320: from pay_all_payrolls_f pa

1316: select pa.payroll_id,
1317: max(pa.effective_end_date)
1318: into v_payroll_id,
1319: v_payroll_end_date
1320: from pay_all_payrolls_f pa
1321: where upper(pa.payroll_name) = upper(p_payroll_name)
1322: and pa.business_group_id + 0 = v_business_group_id
1323: and pa.effective_start_date <= v_effective_end_date
1324: and pa.effective_end_date >= v_effective_start_date