APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PEP_CACHE

Line 438: ben_pep_cache.get_pilpep_dets(

434: -- plan in program is overriden, capture the data from cache by
435: -- passing plip_id
436: --
437: if p_opt_id is null and p_pgm_id is not null then
438: ben_pep_cache.get_pilpep_dets(
439: p_person_id => p_person_id,
440: p_business_group_id => p_business_group_id,
441: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
442: p_pgm_id => p_pgm_id,

Line 449: ben_pep_cache.get_pilepo_dets(

445: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
446: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
447: l_per_los := l_epo_row.rt_los_val;
448: elsif p_opt_id is not null and p_pgm_id is not null then
449: ben_pep_cache.get_pilepo_dets(
450: p_person_id => p_person_id,
451: p_business_group_id => p_business_group_id,
452: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
453: p_pgm_id => p_pgm_id,

Line 646: ben_pep_cache.get_pilpep_dets(

642: -- plan in program is overriden, capture the data from cache by
643: -- passing plip_id
644: --
645: if p_opt_id is null and p_pgm_id is not null then
646: ben_pep_cache.get_pilpep_dets(
647: p_person_id => p_person_id,
648: p_business_group_id => p_business_group_id,
649: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
650: p_pgm_id => p_pgm_id,

Line 657: ben_pep_cache.get_pilepo_dets(

653: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
654: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
655: l_per_age := l_epo_row.rt_age_val;
656: elsif p_opt_id is not null and p_pgm_id is not null then
657: ben_pep_cache.get_pilepo_dets(
658: p_person_id => p_person_id,
659: p_business_group_id => p_business_group_id,
660: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
661: p_pgm_id => p_pgm_id,

Line 857: ben_pep_cache.get_pilpep_dets(

853: -- plan in program is overriden, capture the data from cache by
854: -- passing plip_id
855: --
856: if p_opt_id is null and p_pgm_id is not null then
857: ben_pep_cache.get_pilpep_dets(
858: p_person_id => p_person_id,
859: p_business_group_id => p_business_group_id,
860: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
861: p_pgm_id => p_pgm_id,

Line 868: ben_pep_cache.get_pilepo_dets(

864: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
865: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
866: l_per_cmbn_age_los := l_epo_row.rt_cmbn_age_n_los_val;
867: elsif p_opt_id is not null and p_pgm_id is not null then
868: ben_pep_cache.get_pilepo_dets(
869: p_person_id => p_person_id,
870: p_business_group_id => p_business_group_id,
871: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
872: p_pgm_id => p_pgm_id,