DBA Data[Home] [Help]

APPS.BEN_RECN_REP dependencies on PAY_ALL_PAYROLLS_F

Line 276: ,pay_all_payrolls_f pay

272: ,ben_prtt_prem_by_mo_f mpr
273: ,ben_per_in_ler pil
274: ,per_all_people_f per
275: ,per_person_types ptp
276: ,pay_all_payrolls_f pay
277: ,per_time_periods pds
278: ,per_all_assignments_f asg
279: where pen.pl_id = p_pl_id
280: and (pen.pgm_id = p_pgm_id or p_pgm_id is null)

Line 380: ,pay_all_payrolls_f pay

376: ,ben_prtt_prem_by_mo_f mpr
377: ,ben_per_in_ler pil
378: ,per_all_people_f per
379: ,per_person_types ptp
380: ,pay_all_payrolls_f pay
381: ,per_time_periods pds
382: ,per_all_assignments_f asg
383: where pen.pl_id = p_pl_id
384: and (pen.pgm_id = p_pgm_id or p_pgm_id is null)

Line 1853: from pay_all_payrolls_f pay

1849: where rptg_grp_id = p_rptg_grp_id;
1850: --
1851: cursor c_payroll is
1852: select pay.payroll_name
1853: from pay_all_payrolls_f pay
1854: where pay.payroll_id = p_payroll_id
1855: and p_run_date between pay.effective_start_date and pay.effective_end_date ;
1856:
1857: --