DBA Data[Home] [Help]

APPS.PQP_FTE_UTILITIES dependencies on PAY_ALL_PAYROLLS_F

Line 2185: FROM pay_all_payrolls_f a

2181: IF p_payroll_id IS NOT NULL
2182: THEN
2183: SELECT a.payroll_name
2184: INTO l_log_string
2185: FROM pay_all_payrolls_f a
2186: WHERE a.payroll_id = p_payroll_id
2187: AND effective_start_date =
2188: (SELECT MAX(b.effective_start_date)
2189: FROM pay_all_payrolls_f b

Line 2189: FROM pay_all_payrolls_f b

2185: FROM pay_all_payrolls_f a
2186: WHERE a.payroll_id = p_payroll_id
2187: AND effective_start_date =
2188: (SELECT MAX(b.effective_start_date)
2189: FROM pay_all_payrolls_f b
2190: WHERE b.payroll_id = a.payroll_id
2191: );
2192: END IF;
2193: