eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EFC_ADJUSTMENTS1 dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1882: (element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type

1878: --
1879: TYPE cur_type IS REF CURSOR;
1880: --
1881: type g_efc_row is record
1882: (element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type
1883: ,effective_start_date pay_element_entry_values_f.effective_start_date%type
1884: ,effective_end_date pay_element_entry_values_f.effective_end_date%type
1885: ,prv_creation_date ben_prtt_rt_val.creation_date%type
1886: ,prv_last_update_date ben_prtt_rt_val.last_update_date%type

Line 1883: ,effective_start_date pay_element_entry_values_f.effective_start_date%type

1879: TYPE cur_type IS REF CURSOR;
1880: --
1881: type g_efc_row is record
1882: (element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type
1883: ,effective_start_date pay_element_entry_values_f.effective_start_date%type
1884: ,effective_end_date pay_element_entry_values_f.effective_end_date%type
1885: ,prv_creation_date ben_prtt_rt_val.creation_date%type
1886: ,prv_last_update_date ben_prtt_rt_val.last_update_date%type
1887: ,prv_last_update_login ben_prtt_rt_val.last_update_login%type

Line 1884: ,effective_end_date pay_element_entry_values_f.effective_end_date%type

1880: --
1881: type g_efc_row is record
1882: (element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type
1883: ,effective_start_date pay_element_entry_values_f.effective_start_date%type
1884: ,effective_end_date pay_element_entry_values_f.effective_end_date%type
1885: ,prv_creation_date ben_prtt_rt_val.creation_date%type
1886: ,prv_last_update_date ben_prtt_rt_val.last_update_date%type
1887: ,prv_last_update_login ben_prtt_rt_val.last_update_login%type
1888: ,prv_created_by ben_prtt_rt_val.created_by%type

Line 1889: ,screen_entry_value pay_element_entry_values_f.screen_entry_value%type

1885: ,prv_creation_date ben_prtt_rt_val.creation_date%type
1886: ,prv_last_update_date ben_prtt_rt_val.last_update_date%type
1887: ,prv_last_update_login ben_prtt_rt_val.last_update_login%type
1888: ,prv_created_by ben_prtt_rt_val.created_by%type
1889: ,screen_entry_value pay_element_entry_values_f.screen_entry_value%type
1890: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type
1891: ,business_group_id ben_prtt_rt_val.business_group_id%type
1892: ,prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type
1893: ,acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type

Line 1904: ,ELEMENT_ENTRY_ID pay_element_entry_values_f.ELEMENT_ENTRY_ID%type

1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type
1901: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1902: ,person_id ben_per_in_ler.person_id%type
1903: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1904: ,ELEMENT_ENTRY_ID pay_element_entry_values_f.ELEMENT_ENTRY_ID%type
1905: );
1906: --
1907: c_efc_rows cur_type;
1908: --

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 2085: l_from_str := ' FROM pay_element_entry_values_f eev, '

2081: l_efc_batch := TRUE;
2082: --
2083: end if;
2084: --
2085: l_from_str := ' FROM pay_element_entry_values_f eev, '
2086: ||' ben_prtt_rt_val prv, '
2087: ||' ben_prtt_enrt_rslt_f pen, '
2088: ||' ben_acty_base_rt_f abr, '
2089: ||' ben_per_in_ler pil, '

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 2679: update PAY_ELEMENT_ENTRY_VALUES_F eev

2675: and (l_faterr_code is null
2676: or nvl(l_faterr_type,'ZZZZ') = 'CONVEXCLUSION')
2677: then
2678: --
2679: update PAY_ELEMENT_ENTRY_VALUES_F eev
2680: set eev.screen_entry_value = l_eev_screen_entry_value
2681: where eev.ELEMENT_ENTRY_VALUE_id = l_efc_row.ELEMENT_ENTRY_VALUE_id
2682: and eev.effective_start_date = l_efc_row.effective_start_date;
2683: --

Line 2823: ||' from pay_element_entry_values_f eev, '

2819: --
2820: -- Check that all rows have been converted or excluded
2821: --
2822: l_sql_str := 'select count(*) '
2823: ||' from pay_element_entry_values_f eev, '
2824: ||' ben_prtt_rt_val prv '
2825: ||' where prv.element_entry_value_id = eev.element_entry_value_id '
2826: ||' and eev.screen_entry_value is not null ';
2827: --

Line 2835: (p_table_name => 'pay_element_entry_values_f'

2831: --
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 '

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