APPS.HR_PAY_INTERFACE_PKG dependencies on BEN_OIPL_F

Line 26: ben_oipl_f cop

22: l_name ben_opt_f.name%TYPE;
23: -- define the cursor
24: CURSOR CSR1 IS SELECT opt.name /*coverage_type*/
25: FROM ben_opt_f opt,
26: ben_oipl_f cop
27: WHERE opt.opt_id = cop.opt_id
28: AND cop.oipl_id = P_OIPL_ID
29: AND cop.effective_start_date =
30: (SELECT max(cop1.effective_start_date)

Line 31: FROM ben_oipl_f cop1

27: WHERE opt.opt_id = cop.opt_id
28: AND cop.oipl_id = P_OIPL_ID
29: AND cop.effective_start_date =
30: (SELECT max(cop1.effective_start_date)
31: FROM ben_oipl_f cop1
32: WHERE cop1.oipl_id = cop.oipl_id
33: AND cop1.effective_start_date <= hr_pay_interface_pkg.get_extract_date)
34: AND opt.effective_start_date =
35: (SELECT max(opt1.effective_start_date)