APPS.BEN_EFC_ADJUSTMENTS1 dependencies on BEN_PRTT_RT_VAL_EFC

Line 370: from ben_prtt_rt_val_efc prvefc

366: ,c_worker_id number
367: )
368: is
369: select prvefc.prtt_rt_val_id
370: from ben_prtt_rt_val_efc prvefc
371: where prvefc.efc_action_id = c_efc_action_id
372: and prvefc.prtt_rt_val_id > c_pk1
373: and mod(prvefc.prtt_rt_val_id, c_total_workers) = c_worker_id;
374: --

Line 432: from ben_prtt_rt_val_efc efc

428: efc.ann_rt_val,
429: efc.cmcd_rt_val,
430: efc.pgm_uom,
431: efc.nip_pl_uom
432: from ben_prtt_rt_val_efc efc
433: where efc.efc_action_id = c_efc_action_id
434: and efc.prtt_rt_val_id = c_prv_id;
435: --
436: l_preconvdets c_preconvdets%rowtype;

Line 960: l_from_str := l_from_str||', ben_prtt_rt_val_efc efc ';

956: -- Build in batch specific restrictions
957: --
958: if l_efc_batch then
959: --
960: l_from_str := l_from_str||', ben_prtt_rt_val_efc efc ';
961: l_where_str := l_where_str||' and efc.prtt_rt_val_id = prv.prtt_rt_val_id '
962: ||' and efc.efc_action_id = :action_id '
963: ||' and prv.prtt_rt_val_id > :pk1 '
964: ||' and mod(prv.prtt_rt_val_id, :total_workers) = :worker_id ';

Line 1824: ,p_efctable_name => 'ben_prtt_rt_val_efc'

1820: --Bug 5049253
1821: --
1822: ben_efc_functions.conv_check
1823: (p_table_name => 'ben_prtt_rt_val'
1824: ,p_efctable_name => 'ben_prtt_rt_val_efc'
1825: ,p_tabwhere_clause => ' (rt_val is not null '
1826: ||' or ann_rt_val is not null '
1827: ||' or cmcd_rt_val is not null) '
1828: ,p_bgp_id => p_business_group_id

Line 2046: from ben_prtt_rt_val_efc efc

2042: ,c_efc_action_id number
2043: )
2044: is
2045: select efc.efc_action_id
2046: from ben_prtt_rt_val_efc efc
2047: where efc.efc_action_id = c_efc_action_id
2048: and efc.prtt_rt_val_id = c_prv_id;
2049: --
2050: l_convvalexist c_convvalexist%rowtype;