DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_ALL_PAYROLLS_F

Line 10292: pay_all_payrolls_f ppf

10288: SELECT 1
10289: FROM per_all_assignments_f paf,
10290: hr_organization_information hoi,
10291: pqp_pension_types_f pty,
10292: pay_all_payrolls_f ppf
10293: WHERE paf.assignment_id = p_assignment_id
10294: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
10295: AND paf.payroll_id = ppf.payroll_id
10296: AND ppf.prl_information_category = 'NL'

Line 10444: pay_all_payrolls_f ppf

10440: ,'FPU_T' ,'B') fpu_code
10441: FROM per_all_assignments_f paf,
10442: hr_organization_information hoi,
10443: pqp_pension_types_f pty,
10444: pay_all_payrolls_f ppf
10445: WHERE paf.assignment_id = p_assignment_id
10446: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
10447: AND paf.payroll_id = ppf.payroll_id
10448: AND ppf.prl_information_category = 'NL'