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 1018: l_oipl_id ben_oipl_f.oipl_id%TYPE;

1014: --
1015: l_plninst_set ben_pln_cache.g_bgppln_cache;
1016: l_copinst_set ben_cop_cache.g_bgpcop_cache;
1017: --
1018: l_oipl_id ben_oipl_f.oipl_id%TYPE;
1019: l_pl_id ben_pl_f.pl_id%TYPE;
1020: l_pgm_id ben_pgm_f.pgm_id%TYPE;
1021: l_pgm pgm_rec;
1022: l_pln ben_pln_cache.g_bgppln_rec;

Line 1206: FROM ben_oipl_f cop, ben_opt_f opt

1202: user. (OIPL) */
1203: AND (
1204: EXISTS
1205: (SELECT NULL
1206: FROM ben_oipl_f cop, ben_opt_f opt
1207: WHERE cop.pl_id = NVL(p_pl_id, cop.pl_id)
1208: AND cop.opt_id = p_opt_id
1209: AND cop.oipl_stat_cd = 'A'
1210: AND cop.business_group_id = pgm.business_group_id

Line 1474: FROM ben_oipl_f cop

1470:
1471: AND (
1472: EXISTS
1473: (SELECT NULL
1474: FROM ben_oipl_f cop
1475: WHERE cop.opt_id = p_opt_id
1476: AND cop.pl_id = pln.pl_id
1477: AND cop.oipl_stat_cd = 'A'
1478: AND cop.business_group_id = pln.business_group_id

Line 1630: FROM ben_oipl_f cop

1626: cop.opt_id,
1627: cop.drvbl_fctr_prtn_elig_flag,
1628: cop.drvbl_fctr_apls_rts_flag,
1629: cop.trk_inelig_per_flag
1630: FROM ben_oipl_f cop
1631: ,ben_opt_f opt
1632: -- ,ben_popl_yr_perd cpy
1633: -- ,ben_yr_perd yrp
1634: ,ben_pl_f pln

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

1924: l_tabname_set(1) := 'ben_ptip_f';
1925: l_tabname_set(2) := 'ben_plip_f';
1926: l_tabname_set(3) := 'ben_pl_f';
1927: l_tabname_set(4) := 'ben_opt_f';
1928: l_tabname_set(5) := 'ben_oipl_f';
1929: l_tabname_set(6) := 'ben_oiplip_f';
1930: --
1931: l_tabname_set(7) := 'ben_prtn_elig_f';
1932: l_tabname_set(8) := 'ben_prtn_elig_prfl_f';

Line 2948: FROM ben_oipl_f cop

2944: AND p_effective_date BETWEEN cpp.effective_start_date AND cpp.effective_end_date;
2945: --
2946: CURSOR c_oipl (cv_oipl_id number) IS
2947: SELECT cop.drvbl_fctr_prtn_elig_flag, cop.drvbl_fctr_apls_rts_flag, cop.trk_inelig_per_flag
2948: FROM ben_oipl_f cop
2949: WHERE cop.oipl_id = cv_oipl_id
2950: AND cop.oipl_stat_cd = 'A'
2951: AND p_effective_date BETWEEN cop.effective_start_date AND cop.effective_end_date;
2952: --