APPS.GHR_FORMULA_FUNCTIONS dependencies on BEN_OIPL_F

Line 1133: l_oipl_id ben_oipl_f.oipl_id%type;

1129: --l_date_of_birth Date;
1130: l_tspc_rate_start_dt Date;
1131: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1132: l_pl_id ben_pl_f.pl_id%type;
1133: l_oipl_id ben_oipl_f.oipl_id%type;
1134: l_opt_name ben_opt_f.name%type;
1135:
1136:
1137: l_db_last_pay_end_date Date;

Line 1215: where opt_id in (select opt_id from ben_oipl_f

1211: and prtt_enrt_rslt_stat_cd is null;
1212:
1213: Cursor c_get_opt_name is
1214: select name from ben_opt_f
1215: where opt_id in (select opt_id from ben_oipl_f
1216: where oipl_id = l_oipl_id
1217: and p_effective_date between effective_start_date and
1218: effective_end_date)
1219: and p_effective_date between effective_start_date and effective_end_date;