APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_OIPL_F

Line 149: from ben_oipl_f otp

145: and vpf.effective_end_date';
146: --
147: l_opt_sql VARCHAR2(2000)
148: := 'select opt_id
149: from ben_oipl_f otp
150: where otp.oipl_id = :otp_oipl_id
151: and :otp_effective_date
152: between otp.effective_start_date
153: and otp.effective_end_date

Line 1003: l_oipl_id ben_oipl_f.oipl_id%TYPE;

999: --
1000: l_plninst_set ben_pln_cache.g_bgppln_cache;
1001: l_copinst_set ben_cop_cache.g_bgpcop_cache;
1002: --
1003: l_oipl_id ben_oipl_f.oipl_id%TYPE;
1004: l_pl_id ben_pl_f.pl_id%TYPE;
1005: l_pgm_id ben_pgm_f.pgm_id%TYPE;
1006: l_pgm pgm_rec;
1007: l_pln ben_pln_cache.g_bgppln_rec;

Line 1191: FROM ben_oipl_f cop, ben_opt_f opt

1187: user. (OIPL) */
1188: AND (
1189: EXISTS
1190: (SELECT NULL
1191: FROM ben_oipl_f cop, ben_opt_f opt
1192: WHERE cop.pl_id = NVL(p_pl_id, cop.pl_id)
1193: AND cop.opt_id = p_opt_id
1194: AND cop.oipl_stat_cd = 'A'
1195: AND cop.business_group_id = pgm.business_group_id

Line 1459: FROM ben_oipl_f cop

1455:
1456: AND (
1457: EXISTS
1458: (SELECT NULL
1459: FROM ben_oipl_f cop
1460: WHERE cop.opt_id = p_opt_id
1461: AND cop.pl_id = pln.pl_id
1462: AND cop.oipl_stat_cd = 'A'
1463: AND cop.business_group_id = pln.business_group_id

Line 1615: FROM ben_oipl_f cop

1611: cop.opt_id,
1612: cop.drvbl_fctr_prtn_elig_flag,
1613: cop.drvbl_fctr_apls_rts_flag,
1614: cop.trk_inelig_per_flag
1615: FROM ben_oipl_f cop
1616: ,ben_opt_f opt
1617: -- ,ben_popl_yr_perd cpy
1618: -- ,ben_yr_perd yrp
1619: ,ben_pl_f pln

Line 1910: l_tabname_set(5) := 'ben_oipl_f';

1906: l_tabname_set(1) := 'ben_ptip_f';
1907: l_tabname_set(2) := 'ben_plip_f';
1908: l_tabname_set(3) := 'ben_pl_f';
1909: l_tabname_set(4) := 'ben_opt_f';
1910: l_tabname_set(5) := 'ben_oipl_f';
1911: l_tabname_set(6) := 'ben_oiplip_f';
1912: --
1913: l_tabname_set(7) := 'ben_prtn_elig_f';
1914: l_tabname_set(8) := 'ben_prtn_elig_prfl_f';

Line 2928: FROM ben_oipl_f cop

2924: AND p_effective_date BETWEEN cpp.effective_start_date AND cpp.effective_end_date;
2925: --
2926: CURSOR c_oipl (cv_oipl_id number) IS
2927: SELECT cop.drvbl_fctr_prtn_elig_flag, cop.drvbl_fctr_apls_rts_flag, cop.trk_inelig_per_flag
2928: FROM ben_oipl_f cop
2929: WHERE cop.oipl_id = cv_oipl_id
2930: AND cop.oipl_stat_cd = 'A'
2931: AND p_effective_date BETWEEN cop.effective_start_date AND cop.effective_end_date;
2932: --