APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_OPT_F

Line 1026: l_opt ben_opt_f%ROWTYPE;

1022: l_pln ben_pln_cache.g_bgppln_rec;
1023: l_cop ben_cop_cache.g_bgpcop_rec;
1024: l_plip ben_plip_f%ROWTYPE;
1025: l_ptip ben_ptip_f%ROWTYPE;
1026: l_opt ben_opt_f%ROWTYPE;
1027: l_oiplip ben_oiplip_f%ROWTYPE;
1028: l_epa ben_prtn_elig_f%ROWTYPE;
1029: l_plnnip_set ben_pln_cache.g_nipplnpln_cache;
1030: l_inst_count NUMBER;

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

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

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

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