APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_ACTL_PREM_F

Line 92: from ben_actl_prem_f_efc efc

88: ,c_action_id number
89: )
90: is
91: select efc.uom
92: from ben_actl_prem_f_efc efc
93: where efc.efc_action_id = c_action_id
94: and efc.actl_prem_id = c_apr_id
95: and efc.effective_start_date = c_esd;
96: --

Line 223: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_ACTL_PREM_F';

219: --
220: l_ele_num := 1;
221: --
222: l_rndgtabnm_set.extend(1);
223: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_ACTL_PREM_F';
224: l_rndgtabnm_set(l_ele_num).pkcol_name := 'ACTL_PREM_ID';
225: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'RNDG_CD';
226: l_rndgtabnm_set(l_ele_num).ent_scode := 'APR';
227: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 410: if l_rndgtab_name = 'BEN_ACTL_PREM_F'

406: if p_modify then
407: --
408: -- Get the currency code
409: --
410: if l_rndgtab_name = 'BEN_ACTL_PREM_F'
411: then
412: --
413: open c_get_apr_currcode
414: (c_apr_id => l_rndgcodedets.id

Line 567: and l_rndgtab_name = 'BEN_ACTL_PREM_F'

563: ,p_rndcd_value => l_rndgcodedets.rndgcol_value
564: );
565: --
566: if l_newrndg_code is not null
567: and l_rndgtab_name = 'BEN_ACTL_PREM_F'
568: then
569: --
570: update ben_actl_prem_f
571: set rndg_cd = l_newrndg_code

Line 570: update ben_actl_prem_f

566: if l_newrndg_code is not null
567: and l_rndgtab_name = 'BEN_ACTL_PREM_F'
568: then
569: --
570: update ben_actl_prem_f
571: set rndg_cd = l_newrndg_code
572: where actl_prem_id = l_rndgcodedets.id
573: and effective_start_date = l_rndgcodedets.effective_start_date;
574: --