DBA Data[Home] [Help]

APPS.PQP_FTE_UTILITIES dependencies on PAY_ALL_PAYROLLS_F

Line 2130: FROM pay_all_payrolls_f a

2126: IF p_payroll_id IS NOT NULL
2127: THEN
2128: SELECT a.payroll_name
2129: INTO l_log_string
2130: FROM pay_all_payrolls_f a
2131: WHERE a.payroll_id = p_payroll_id
2132: AND effective_start_date =
2133: (SELECT MAX(b.effective_start_date)
2134: FROM pay_all_payrolls_f b

Line 2134: FROM pay_all_payrolls_f b

2130: FROM pay_all_payrolls_f a
2131: WHERE a.payroll_id = p_payroll_id
2132: AND effective_start_date =
2133: (SELECT MAX(b.effective_start_date)
2134: FROM pay_all_payrolls_f b
2135: WHERE b.payroll_id = a.payroll_id
2136: );
2137: END IF;
2138: