DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on PAY_ALL_PAYROLLS_F

Line 1322: from pay_all_payrolls_f pa

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