APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PAY_PAYROLLS_F

Line 290: FROM pay_payrolls_f pay

286: WHERE hou.organization_id = p_bg_id;
287: ---------------------
288: CURSOR csr_payroll_details(p_payroll_id NUMBER, p_effective_date DATE) IS
289: SELECT pay.payroll_name
290: FROM pay_payrolls_f pay
291: WHERE pay.payroll_id = p_payroll_id
292: AND p_effective_date BETWEEN pay.effective_start_date
293: AND pay.effective_end_date;
294: ---------------------