APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_COMP_LVL_FCTR

Line 139: from ben_comp_lvl_fctr_efc efc

135: ,c_action_id number
136: )
137: is
138: select efc.comp_lvl_uom
139: from ben_comp_lvl_fctr_efc efc
140: where efc.efc_action_id = c_action_id
141: and efc.comp_lvl_fctr_id = c_clf_id;
142: --
143: cursor c_get_ccm_currcode

Line 255: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_COMP_LVL_FCTR';

251: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';
252: l_ele_num := l_ele_num+1;
253: --
254: l_rndgtabnm_set.extend(1);
255: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_COMP_LVL_FCTR';
256: l_rndgtabnm_set(l_ele_num).pkcol_name := 'COMP_LVL_FCTR_ID';
257: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'RNDG_CD';
258: l_rndgtabnm_set(l_ele_num).ent_scode := 'CLF';
259: l_rndgtabnm_set(l_ele_num).datetracked := 'N';

Line 474: elsif l_rndgtab_name = 'BEN_COMP_LVL_FCTR'

470: --
471: end if;
472: close c_get_bpp_currcode;
473: --
474: elsif l_rndgtab_name = 'BEN_COMP_LVL_FCTR'
475: then
476: --
477: open c_get_clf_currcode
478: (c_clf_id => l_rndgcodedets.id

Line 603: and l_rndgtab_name = 'BEN_COMP_LVL_FCTR'

599: where bnft_prvdr_pool_id = l_rndgcodedets.id
600: and effective_start_date = l_rndgcodedets.effective_start_date;
601: --
602: elsif l_newrndg_code is not null
603: and l_rndgtab_name = 'BEN_COMP_LVL_FCTR'
604: then
605: --
606: update ben_comp_lvl_fctr
607: set rndg_cd = l_newrndg_code

Line 606: update ben_comp_lvl_fctr

602: elsif l_newrndg_code is not null
603: and l_rndgtab_name = 'BEN_COMP_LVL_FCTR'
604: then
605: --
606: update ben_comp_lvl_fctr
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