APPS.GHR_FORMULA_FUNCTIONS dependencies on BEN_OIPL_F

Line 1129: l_oipl_id ben_oipl_f.oipl_id%type;

1125: --l_date_of_birth Date;
1126: l_tspc_rate_start_dt Date;
1127: l_tsp_pgm_id ben_pgm_f.pgm_id%type;
1128: l_pl_id ben_pl_f.pl_id%type;
1129: l_oipl_id ben_oipl_f.oipl_id%type;
1130: l_opt_name ben_opt_f.name%type;
1131:
1132:
1133: l_db_last_pay_end_date Date;

Line 1211: where opt_id in (select opt_id from ben_oipl_f

1207: and prtt_enrt_rslt_stat_cd is null;
1208:
1209: Cursor c_get_opt_name is
1210: select name from ben_opt_f
1211: where opt_id in (select opt_id from ben_oipl_f
1212: where oipl_id = l_oipl_id
1213: and p_effective_date between effective_start_date and
1214: effective_end_date)
1215: and p_effective_date between effective_start_date and effective_end_date;