APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_ELIG_PER_OPT_F

Line 1154: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

1150: );
1151:
1152: cursor c_pct_ft_opt is
1153: select epo.rt_pct_fl_tm_val
1154: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1155: ben_per_in_ler pil
1156: where bep.person_id = p_person_id
1157: and bep.elig_per_id = epo.elig_per_id
1158: and epo.opt_id = p_opt_id

Line 1172: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

1168: or pil.per_in_ler_stat_cd is null); -- outer join condition
1169:
1170: cursor c_pct_ft_plip is
1171: select epo.rt_pct_fl_tm_val
1172: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1173: ben_per_in_ler pil
1174: where bep.person_id = p_person_id
1175: and bep.elig_per_id = epo.elig_per_id
1176: and epo.opt_id = p_opt_id

Line 1497: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

1493: or pil.per_in_ler_stat_cd is null); -- outer join condition
1494:
1495: cursor c_hrs_wkd_opt is
1496: select epo.rt_hrs_wkd_val
1497: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1498: ben_per_in_ler pil
1499: where bep.person_id = p_person_id
1500: and bep.elig_per_id = epo.elig_per_id
1501: and epo.opt_id = p_opt_id

Line 1515: from ben_elig_per_f bep, ben_elig_per_opt_f epo,

1511: or pil.per_in_ler_stat_cd is null); -- outer join condition
1512:
1513: cursor c_hrs_wkd_plip is
1514: select epo.rt_hrs_wkd_val
1515: from ben_elig_per_f bep, ben_elig_per_opt_f epo,
1516: ben_per_in_ler pil
1517: where bep.person_id = p_person_id
1518: and bep.elig_per_id = epo.elig_per_id
1519: and epo.opt_id = p_opt_id