DBA Data[Home] [Help]

APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_OPT_F

Line 2386: ben_opt_f opt

2382: epe.elctbl_flag,
2383: epe.elig_per_elctbl_chc_id
2384: From ben_elig_per_elctbl_chc epe,
2385: ben_oipl_f oipl,
2386: ben_opt_f opt
2387: Where epe.per_in_ler_id = p_per_in_ler_id
2388: AND epe.plip_id = p_plip_id
2389: AND epe.comp_lvl_cd = 'OIPL'
2390: AND epe.oipl_id = oipl.oipl_id

Line 2403: ben_opt_f opt

2399: epe.elctbl_flag,
2400: epe.elig_per_elctbl_chc_id
2401: From ben_elig_per_elctbl_chc epe,
2402: ben_oipl_f oipl,
2403: ben_opt_f opt
2404: Where epe.per_in_ler_id = p_per_in_ler_id
2405: AND epe.plip_id is NULL and epe.pl_id=p_pl_id
2406: AND epe.comp_lvl_cd = 'OIPL'
2407: AND epe.oipl_id = oipl.oipl_id

Line 3042: ben_opt_f opt

3038: epe.elctbl_flag,
3039: epe.elig_per_elctbl_chc_id
3040: From ben_elig_per_elctbl_chc epe,
3041: ben_oipl_f oipl,
3042: ben_opt_f opt
3043: Where epe.per_in_ler_id = p_per_in_ler_id
3044: AND epe.plip_id = p_plip_id
3045: AND epe.comp_lvl_cd = 'OIPL'
3046: AND epe.oipl_id = oipl.oipl_id

Line 3059: ben_opt_f opt

3055: epe.elctbl_flag,
3056: epe.elig_per_elctbl_chc_id
3057: From ben_elig_per_elctbl_chc epe,
3058: ben_oipl_f oipl,
3059: ben_opt_f opt
3060: Where epe.per_in_ler_id = p_per_in_ler_id
3061: AND epe.plip_id is NULL and epe.pl_id=p_pl_id
3062: AND epe.comp_lvl_cd = 'OIPL'
3063: AND epe.oipl_id = oipl.oipl_id