APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ENRT_RT_EFC

Line 4805: from ben_enrt_rt_efc efc

4801: efc.MN_ELCN_VAL,
4802: efc.INCRMT_ELCN_VAL,
4803: efc.VAL,
4804: nvl(efc.pgm_uom,efc.nip_pl_uom) uom
4805: from ben_enrt_rt_efc efc
4806: where efc.efc_action_id = c_efc_action_id
4807: and efc.enrt_rt_id = c_ecr_id;
4808: --
4809: l_preconvdets c_preconvdets%rowtype;

Line 4867: l_from_str := l_from_str||', ben_enrt_rt_efc efc ';

4863: -- Build in batch specific restrictions
4864: --
4865: if l_efc_batch then
4866: --
4867: l_from_str := l_from_str||', ben_enrt_rt_efc efc ';
4868: l_where_str := l_where_str||' and efc.enrt_rt_id = ecr.enrt_rt_id '
4869: ||' and efc.efc_action_id = :action_id '
4870: ||' and ecr.enrt_rt_id > :pk1 '
4871: ||' and mod(ecr.enrt_rt_id, :total_workers) = :worker_id ';

Line 5780: ,p_efctable_name => 'ben_enrt_rt_efc'

5776: -- Check that all rows have been converted or excluded
5777: --
5778: ben_efc_functions.conv_check
5779: (p_table_name => 'ben_enrt_rt'
5780: ,p_efctable_name => 'ben_enrt_rt_efc'
5781: ,p_tabwhere_clause => ' (cmcd_mn_elcn_val is not null '
5782: ||' or cmcd_mn_elcn_val is not null '
5783: ||' or cmcd_mx_elcn_val is not null '
5784: ||' or cmcd_val is not null '