APPS.BEN_EFC_ADJUSTMENTS1 dependencies on PAY_ELEMENT_ENTRY_VALUES_F_EFC

Line 2018: from pay_element_entry_values_f_efc efc

2014: )
2015: is
2016: select efc.SCREEN_ENTRY_VALUE,
2017: efc.input_currency_code
2018: from pay_element_entry_values_f_efc efc
2019: where efc.efc_action_id = c_efc_action_id
2020: and efc.element_entry_value_id = c_eev_id
2021: and efc.effective_start_date = c_eev_esd;
2022: --

Line 2141: l_from_str := l_from_str||', pay_element_entry_values_f_efc efc ';

2137: -- Build in batch specific restrictions
2138: --
2139: if l_efc_batch then
2140: --
2141: l_from_str := l_from_str||', pay_element_entry_values_f_efc efc ';
2142: l_where_str := l_where_str||' and efc.element_entry_value_id = eev.element_entry_value_id '
2143: ||' and efc.effective_start_date = eev.effective_start_date '
2144: ||' and efc.efc_action_id = :action_id '
2145: ||' and eev.element_entry_value_id > :pk1 '

Line 2836: ,p_efctable_name => 'pay_element_entry_values_f_efc'

2832: end if;
2833: --
2834: ben_efc_functions.conv_check
2835: (p_table_name => 'pay_element_entry_values_f'
2836: ,p_efctable_name => 'pay_element_entry_values_f_efc'
2837: --
2838: ,p_table_sql => l_sql_str
2839: ,p_efctable_sql => 'select count(*) from pay_element_entry_values_f_efc '
2840: ||' where efc_action_id = '||p_action_id

Line 2839: ,p_efctable_sql => 'select count(*) from pay_element_entry_values_f_efc '

2835: (p_table_name => 'pay_element_entry_values_f'
2836: ,p_efctable_name => 'pay_element_entry_values_f_efc'
2837: --
2838: ,p_table_sql => l_sql_str
2839: ,p_efctable_sql => 'select count(*) from pay_element_entry_values_f_efc '
2840: ||' where efc_action_id = '||p_action_id
2841: --
2842: ,p_bgp_id => p_business_group_id
2843: ,p_action_id => p_action_id