APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on BEN_OPT_F

Line 1419: from ben_opt_f opt

1415: cursor c_GroupOptionIdLovVO( cv_name varchar2, cv_effective_date date) is
1416: select
1417: opt.name Name ,
1418: Opt.opt_id
1419: from ben_opt_f opt
1420: where opt.opt_id = opt.group_opt_id
1421: and opt.name = cv_name
1422: and trunc(cv_effective_date) between
1423: opt.effective_start_date and opt.effective_end_date;

Line 2022: elsif (l_table_route_name = 'BEN_OPT_F') then

2018: , p_target_id2 =>l_ret.information180
2019: );
2020: --
2021: end loop;
2022: elsif (l_table_route_name = 'BEN_OPT_F') then
2023: --
2024: for l_ret in c_source_data (p_table_route_id)
2025: loop
2026: --

Line 2256: --'BEN_OPT_F',

2252: from pqh_table_route
2253: where table_route_id = p_table_route_id
2254: and where_clause in('BEN_HRS_WKD_IN_PERD_FCTR',
2255: --'BEN_PL_F',
2256: --'BEN_OPT_F',
2257: --'BEN_POPL_ORG_F',
2258: 'BEN_COMP_LVL_FCTR',
2259: 'BEN_ENRT_PERD'); -- Bug No 4498668
2260: --