APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PEP_CACHE

Line 3024: ben_pep_cache.get_pilpep_dets(

3020: if l_inst_count > 0 then
3021: --
3022: -- plan in program is overriden, capture the data from cache by passing plip_id
3023: if p_opt_id is null and p_pgm_id is not null then
3024: ben_pep_cache.get_pilpep_dets(
3025: p_person_id => p_person_id,
3026: p_business_group_id => p_business_group_id,
3027: p_effective_date => l_effective_date,
3028: p_pgm_id => p_pgm_id,

Line 3035: ben_pep_cache.get_pilepo_dets(

3031: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
3032: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
3033: l_per_age := l_epo_row.rt_age_val;
3034: elsif p_opt_id is not null and p_pgm_id is not null then
3035: ben_pep_cache.get_pilepo_dets(
3036: p_person_id => p_person_id,
3037: p_business_group_id => p_business_group_id,
3038: p_effective_date => l_effective_date,
3039: p_pgm_id => p_pgm_id,

Line 3463: ben_pep_cache.get_pilpep_dets(

3459: if l_inst_count > 0 then
3460: --
3461: -- plan in program is overriden, capture the data from cache by passing plip_id
3462: if p_opt_id is null and p_pgm_id is not null then
3463: ben_pep_cache.get_pilpep_dets(
3464: p_person_id => p_person_id,
3465: p_business_group_id => p_business_group_id,
3466: p_effective_date => l_effective_date,
3467: p_pgm_id => p_pgm_id,

Line 3474: ben_pep_cache.get_pilepo_dets(

3470: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
3471: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
3472: l_per_los := l_epo_row.rt_los_val;
3473: elsif p_opt_id is not null and p_pgm_id is not null then
3474: ben_pep_cache.get_pilepo_dets(
3475: p_person_id => p_person_id,
3476: p_business_group_id => p_business_group_id,
3477: p_effective_date => l_effective_date,
3478: p_pgm_id => p_pgm_id,

Line 3678: ben_pep_cache.get_pilpep_dets(

3674: if l_inst_count > 0 then
3675: --
3676: -- plan in program is overriden, capture the data from cache by passing plip_id
3677: if p_opt_id is null and p_pgm_id is not null then
3678: ben_pep_cache.get_pilpep_dets(
3679: p_person_id => p_person_id,
3680: p_business_group_id => p_business_group_id,
3681: p_effective_date => l_effective_date,
3682: p_pgm_id => p_pgm_id,

Line 3689: ben_pep_cache.get_pilepo_dets(

3685: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
3686: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
3687: l_cmbn_age_n_los_val := l_epo_row.rt_cmbn_age_n_los_val;
3688: elsif p_opt_id is not null and p_pgm_id is not null then
3689: ben_pep_cache.get_pilepo_dets(
3690: p_person_id => p_person_id,
3691: p_business_group_id => p_business_group_id,
3692: p_effective_date => l_effective_date,
3693: p_pgm_id => p_pgm_id,