DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_ALL_PAYROLLS_F

Line 9953: pay_all_payrolls_f ppf

9949: SELECT 1
9950: FROM per_all_assignments_f paf,
9951: hr_organization_information hoi,
9952: pqp_pension_types_f pty,
9953: pay_all_payrolls_f ppf
9954: WHERE paf.assignment_id = p_assignment_id
9955: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
9956: AND paf.payroll_id = ppf.payroll_id
9957: AND ppf.prl_information_category = 'NL'

Line 10105: pay_all_payrolls_f ppf

10101: ,'FPU_T' ,'B') fpu_code
10102: FROM per_all_assignments_f paf,
10103: hr_organization_information hoi,
10104: pqp_pension_types_f pty,
10105: pay_all_payrolls_f ppf
10106: WHERE paf.assignment_id = p_assignment_id
10107: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
10108: AND paf.payroll_id = ppf.payroll_id
10109: AND ppf.prl_information_category = 'NL'