DBA Data[Home] [Help]

APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_OIPL_F

Line 2385: ben_oipl_f oipl,

2381: opt.name,
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'

Line 2402: ben_oipl_f oipl,

2398: opt.name,
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'

Line 3041: ben_oipl_f oipl,

3037: opt.name,
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'

Line 3058: ben_oipl_f oipl,

3054: opt.name,
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'