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 BEN_PRTT_RT_VAL

Line 146: from ben_prtt_rt_val prv,

142: prv.object_version_number,
143: prv.MLT_CD,
144: pil.person_id,
145: pil.per_in_ler_id
146: from ben_prtt_rt_val prv,
147: ben_prtt_enrt_rslt_f pen,
148: ben_per_in_ler pil
149: where prv.prtt_rt_val_id = c_prv_id
150: and pil.lf_evt_ocrd_dt

Line 187: from ben_prtt_rt_val prv,

183: prv.ann_rt_val,
184: prv.mlt_cd,
185: pil.person_id,
186: prv.RT_END_DT
187: from ben_prtt_rt_val prv,
188: ben_per_in_ler pil
189: where prv.per_in_ler_id = c_pil_id
190: and prv.per_in_ler_id = pil.per_in_ler_id
191: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');

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 868: update ben_prtt_rt_val prv

864: is
865:
866: begin
867: --
868: update ben_prtt_rt_val prv
869: set prv.rt_val = p_rt_val,
870: prv.ann_rt_val = p_ann_rt_val
871: where prv.prtt_rt_val_id = p_prtt_rt_val_id;
872: --

Line 920: l_from_str := ' FROM ben_prtt_rt_val prv, '

916: l_efc_batch := TRUE;
917: --
918: end if;
919: --
920: l_from_str := ' FROM ben_prtt_rt_val prv, '
921: ||' ben_per_in_ler pil, '
922: ||' per_all_people_f per ';
923: --
924: l_where_str := ' where prv.per_in_ler_id = pil.per_in_ler_id '

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 1823: (p_table_name => 'ben_prtt_rt_val'

1819: */
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) '

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 1885: ,prv_creation_date ben_prtt_rt_val.creation_date%type

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
1889: ,screen_entry_value pay_element_entry_values_f.screen_entry_value%type

Line 1886: ,prv_last_update_date ben_prtt_rt_val.last_update_date%type

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
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

Line 1887: ,prv_last_update_login ben_prtt_rt_val.last_update_login%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
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

Line 1888: ,prv_created_by ben_prtt_rt_val.created_by%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
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

Line 1891: ,business_group_id ben_prtt_rt_val.business_group_id%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
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type

Line 1892: ,prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%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
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type

Line 1893: ,acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%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
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type

Line 1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%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
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type

Line 1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%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
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type

Line 1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%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
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type
1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type

Line 1897: ,rt_val ben_prtt_rt_val.rt_val%type

1893: ,acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type
1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_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

Line 1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type

1894: ,acty_base_rt_id ben_prtt_rt_val.acty_base_rt_id%type
1895: ,prtt_enrt_rslt_id ben_prtt_rt_val.prtt_enrt_rslt_id%type
1896: ,rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type
1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_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

Line 1963: from ben_prtt_rt_val

1959: (c_eev_id in number
1960: )
1961: is
1962: select count(*)
1963: from ben_prtt_rt_val
1964: where element_entry_value_id = c_eev_id;
1965: --
1966: cursor c_abrdets
1967: (c_abr_id in number

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;

Line 2086: ||' ben_prtt_rt_val prv, '

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, '
2090: ||' per_all_people_f per ';

Line 2095: ||' from ben_prtt_rt_val prv1 '

2091: --
2092: l_where_str := ' where prv.element_entry_value_id = eev.element_entry_value_id '
2093: ||' and prv.prtt_rt_val_id = '
2094: ||' (select min(prv1.prtt_rt_val_id) '
2095: ||' from ben_prtt_rt_val prv1 '
2096: ||' where prv.element_entry_value_id = prv1.element_entry_value_id '
2097: ||' ) '
2098: ||' and prv.rt_strt_dt '
2099: ||' between pen.effective_start_date and pen.effective_end_date '

Line 2824: ||' ben_prtt_rt_val prv '

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: --
2828: if p_business_group_id is not null then