APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_BNFT_PRVDR_POOL_F

Line 128: from ben_bnft_prvdr_pool_f_efc efc

124: ,c_action_id number
125: )
126: is
127: select efc.pgm_uom
128: from ben_bnft_prvdr_pool_f_efc efc
129: where efc.efc_action_id = c_action_id
130: and efc.bnft_prvdr_pool_id = c_bpp_id
131: and efc.effective_start_date = c_esd;
132: --

Line 247: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_BNFT_PRVDR_POOL_F';

243: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';
244: l_ele_num := l_ele_num+1;
245: --
246: l_rndgtabnm_set.extend(1);
247: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_BNFT_PRVDR_POOL_F';
248: l_rndgtabnm_set(l_ele_num).pkcol_name := 'BNFT_PRVDR_POOL_ID';
249: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'VAL_RNDG_CD';
250: l_rndgtabnm_set(l_ele_num).ent_scode := 'BPP';
251: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 458: elsif l_rndgtab_name = 'BEN_BNFT_PRVDR_POOL_F'

454: --
455: end if;
456: close c_get_bpr_currcode;
457: --
458: elsif l_rndgtab_name = 'BEN_BNFT_PRVDR_POOL_F'
459: then
460: --
461: open c_get_bpp_currcode
462: (c_bpp_id => l_rndgcodedets.id

Line 594: and l_rndgtab_name = 'BEN_BNFT_PRVDR_POOL_F'

590: where bnft_pool_rlovr_rqmt_id = l_rndgcodedets.id
591: and effective_start_date = l_rndgcodedets.effective_start_date;
592: --
593: elsif l_newrndg_code is not null
594: and l_rndgtab_name = 'BEN_BNFT_PRVDR_POOL_F'
595: then
596: --
597: update ben_bnft_prvdr_pool_f
598: set val_rndg_cd = l_newrndg_code

Line 597: update ben_bnft_prvdr_pool_f

593: elsif l_newrndg_code is not null
594: and l_rndgtab_name = 'BEN_BNFT_PRVDR_POOL_F'
595: then
596: --
597: update ben_bnft_prvdr_pool_f
598: set val_rndg_cd = l_newrndg_code
599: where bnft_prvdr_pool_id = l_rndgcodedets.id
600: and effective_start_date = l_rndgcodedets.effective_start_date;
601: --