APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PEP_CACHE

Line 427: ben_pep_cache.get_pilpep_dets(

423: -- plan in program is overriden, capture the data from cache by
424: -- passing plip_id
425: --
426: if p_opt_id is null and p_pgm_id is not null then
427: ben_pep_cache.get_pilpep_dets(
428: p_person_id => p_person_id,
429: p_business_group_id => p_business_group_id,
430: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
431: p_pgm_id => p_pgm_id,

Line 438: ben_pep_cache.get_pilepo_dets(

434: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
435: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
436: l_per_los := l_epo_row.rt_los_val;
437: elsif p_opt_id is not null and p_pgm_id is not null then
438: ben_pep_cache.get_pilepo_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 635: ben_pep_cache.get_pilpep_dets(

631: -- plan in program is overriden, capture the data from cache by
632: -- passing plip_id
633: --
634: if p_opt_id is null and p_pgm_id is not null then
635: ben_pep_cache.get_pilpep_dets(
636: p_person_id => p_person_id,
637: p_business_group_id => p_business_group_id,
638: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
639: p_pgm_id => p_pgm_id,

Line 646: ben_pep_cache.get_pilepo_dets(

642: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
643: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
644: l_per_age := l_epo_row.rt_age_val;
645: elsif p_opt_id is not null and p_pgm_id is not null then
646: ben_pep_cache.get_pilepo_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 846: ben_pep_cache.get_pilpep_dets(

842: -- plan in program is overriden, capture the data from cache by
843: -- passing plip_id
844: --
845: if p_opt_id is null and p_pgm_id is not null then
846: ben_pep_cache.get_pilpep_dets(
847: p_person_id => p_person_id,
848: p_business_group_id => p_business_group_id,
849: p_effective_date => nvl(l_fonm_cvg_strt_dt,p_effective_date),
850: p_pgm_id => p_pgm_id,

Line 857: ben_pep_cache.get_pilepo_dets(

853: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
854: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
855: l_per_cmbn_age_los := l_epo_row.rt_cmbn_age_n_los_val;
856: elsif p_opt_id is not null and p_pgm_id is not null then
857: ben_pep_cache.get_pilepo_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,