APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_OPT_F

Line 1011: l_opt ben_opt_f%ROWTYPE;

1007: l_pln ben_pln_cache.g_bgppln_rec;
1008: l_cop ben_cop_cache.g_bgpcop_rec;
1009: l_plip ben_plip_f%ROWTYPE;
1010: l_ptip ben_ptip_f%ROWTYPE;
1011: l_opt ben_opt_f%ROWTYPE;
1012: l_oiplip ben_oiplip_f%ROWTYPE;
1013: l_epa ben_prtn_elig_f%ROWTYPE;
1014: l_plnnip_set ben_pln_cache.g_nipplnpln_cache;
1015: l_inst_count NUMBER;

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 1616: ,ben_opt_f opt

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
1620: WHERE cop.business_group_id = p_business_group_id

Line 1909: l_tabname_set(4) := 'ben_opt_f';

1905: l_tabname_set(0) := 'ben_pgm_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';