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 3461: ben_pep_cache.get_pilpep_dets(

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

Line 3472: ben_pep_cache.get_pilepo_dets(

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

Line 3674: ben_pep_cache.get_pilpep_dets(

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

Line 3685: ben_pep_cache.get_pilepo_dets(

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