APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 150: from ben_cvg_amt_calc_mthd_f_efc efc

146: ,c_action_id number
147: )
148: is
149: select nvl(efc.pgm_uom,efc.nip_pl_uom)
150: from ben_cvg_amt_calc_mthd_f_efc efc
151: where efc.efc_action_id = c_action_id
152: and efc.cvg_amt_calc_mthd_id = c_ccm_id
153: and efc.effective_start_date = c_esd;
154: --

Line 263: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_CVG_AMT_CALC_MTHD_F';

259: l_rndgtabnm_set(l_ele_num).datetracked := 'N';
260: l_ele_num := l_ele_num+1;
261: --
262: l_rndgtabnm_set.extend(1);
263: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_CVG_AMT_CALC_MTHD_F';
264: l_rndgtabnm_set(l_ele_num).pkcol_name := 'CVG_AMT_CALC_MTHD_ID';
265: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'RNDG_CD';
266: l_rndgtabnm_set(l_ele_num).ent_scode := 'CCM';
267: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 489: elsif l_rndgtab_name = 'BEN_CVG_AMT_CALC_MTHD_F'

485: --
486: end if;
487: close c_get_clf_currcode;
488: --
489: elsif l_rndgtab_name = 'BEN_CVG_AMT_CALC_MTHD_F'
490: then
491: --
492: open c_get_ccm_currcode
493: (c_ccm_id => l_rndgcodedets.id

Line 611: and l_rndgtab_name = 'BEN_CVG_AMT_CALC_MTHD_F'

607: set rndg_cd = l_newrndg_code
608: where comp_lvl_fctr_id = l_rndgcodedets.id;
609: --
610: elsif l_newrndg_code is not null
611: and l_rndgtab_name = 'BEN_CVG_AMT_CALC_MTHD_F'
612: then
613: --
614: update ben_cvg_amt_calc_mthd_f
615: set rndg_cd = l_newrndg_code

Line 614: update ben_cvg_amt_calc_mthd_f

610: elsif l_newrndg_code is not null
611: and l_rndgtab_name = 'BEN_CVG_AMT_CALC_MTHD_F'
612: then
613: --
614: update ben_cvg_amt_calc_mthd_f
615: set rndg_cd = l_newrndg_code
616: where cvg_amt_calc_mthd_id = l_rndgcodedets.id
617: and effective_start_date = l_rndgcodedets.effective_start_date;
618: --