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.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1097: FROM pay_element_types_f

1093: WHERE name LIKE hr_jp_standard_pkg.hextochar('E5BEB4E58F8EE7A88EE9A18D','AL32UTF8')
1094: AND legislation_code = 'JP'
1095: AND element_type_id IN (
1096: SELECT element_type_id
1097: FROM pay_element_types_f
1098: WHERE element_name LIKE hr_jp_standard_pkg.hextochar('E585B1EFBCBFE59FBAE69CACEFBCBFE4BD8FE6B091E7A88EEFBCBFE4B880E68BACE5BEB4E58F8E','AL32UTF8')
1099: AND legislation_code = 'JP' );
1100:
1101: -- update BON_WP_PREM_PROC (, SAL_HI_PREM_PROC, BON_HI_PREM_PROC) elm from WP_PREM_ER to INS_PREM_ER for l_jp_input_names_tab(173) update

Line 1109: FROM pay_element_types_f

1105: WHERE name LIKE hr_jp_standard_pkg.hextochar('E4BA8BE6A5ADE4B8BBE58886E4BF9DE999BAE69699','AL32UTF8')
1106: AND legislation_code = 'JP'
1107: AND element_type_id IN (
1108: SELECT element_type_id
1109: FROM pay_element_types_f
1110: WHERE element_name IN
1111: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1112: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1113: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))

Line 1124: FROM pay_element_types_f

1120: WHERE name LIKE hr_jp_standard_pkg.hextochar('E8A2ABE4BF9DE999BAE88085E58886E4BF9DE999BAE69699','AL32UTF8')
1121: AND legislation_code = 'JP'
1122: AND element_type_id IN (
1123: SELECT element_type_id
1124: FROM pay_element_types_f
1125: WHERE element_name IN
1126: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1127: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1128: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))

Line 1165: type t_element_names_tab is table of pay_element_types_f.element_name%TYPE index by binary_integer;

1161: procedure migrate_element_types is
1162: --
1163: type t_jp_element_names_tab is table of VARCHAR2(200) index by binary_integer;
1164:
1165: type t_element_names_tab is table of pay_element_types_f.element_name%TYPE index by binary_integer;
1166:
1167: type t_element_desc_tab is table of pay_element_types_f.description%TYPE index by binary_integer;
1168:
1169: type t_element_rep_tab is table of pay_element_types_f.reporting_name%TYPE index by binary_integer;

Line 1167: type t_element_desc_tab is table of pay_element_types_f.description%TYPE index by binary_integer;

1163: type t_jp_element_names_tab is table of VARCHAR2(200) index by binary_integer;
1164:
1165: type t_element_names_tab is table of pay_element_types_f.element_name%TYPE index by binary_integer;
1166:
1167: type t_element_desc_tab is table of pay_element_types_f.description%TYPE index by binary_integer;
1168:
1169: type t_element_rep_tab is table of pay_element_types_f.reporting_name%TYPE index by binary_integer;
1170:
1171: l_jp_element_names_tab t_jp_element_names_tab;

Line 1169: type t_element_rep_tab is table of pay_element_types_f.reporting_name%TYPE index by binary_integer;

1165: type t_element_names_tab is table of pay_element_types_f.element_name%TYPE index by binary_integer;
1166:
1167: type t_element_desc_tab is table of pay_element_types_f.description%TYPE index by binary_integer;
1168:
1169: type t_element_rep_tab is table of pay_element_types_f.reporting_name%TYPE index by binary_integer;
1170:
1171: l_jp_element_names_tab t_jp_element_names_tab;
1172: l_element_names_tab t_element_names_tab;
1173: l_element_desc_tab t_element_desc_tab;

Line 2044: UPDATE pay_element_types_f

2040: --
2041:
2042: FORALL l_tab_cnt IN 1..l_jp_element_names_tab.COUNT
2043:
2044: UPDATE pay_element_types_f
2045: SET element_name = l_element_names_tab(l_tab_cnt),
2046: description = l_element_desc_tab(l_tab_cnt),
2047: reporting_name = l_element_rep_tab(l_tab_cnt)
2048: WHERE element_name LIKE hr_jp_standard_pkg.hextochar(l_jp_element_names_tab(l_tab_cnt),'AL32UTF8')

Line 2051: UPDATE pay_element_types_f

2047: reporting_name = l_element_rep_tab(l_tab_cnt)
2048: WHERE element_name LIKE hr_jp_standard_pkg.hextochar(l_jp_element_names_tab(l_tab_cnt),'AL32UTF8')
2049: AND legislation_code = 'JP';
2050:
2051: UPDATE pay_element_types_f
2052: SET description = description || 'Obsoleted'
2053: WHERE ASCII(description) > 127
2054: AND legislation_code = 'JP';
2055:

Line 5156: from pay_element_types_f pet

5152: -- so effective for only bug 10040338 user
5153: cursor csr_elm_cnt
5154: is
5155: select count(pet.element_type_id)
5156: from pay_element_types_f pet
5157: where pet.legislation_code = 'JP'
5158: and ascii(pet.element_name) <= 127
5159: and pet.element_name not in (
5160: 'BON_HI_PREM_ROUNDING_ERROR',

Line 5168: from pay_element_types_f pet2

5164: 'YEA_HOUSING_LOAN_INFO',
5165: 'Yea Insurance Deduction Form')
5166: and exists(
5167: select null
5168: from pay_element_types_f pet2
5169: where pet2.legislation_code = 'JP'
5170: and ascii(pet2.element_name) > 127
5171: and pet2.description not like '%Obsoleted');
5172: --

Line 5515: -- from pay_element_types_f pet

5511: -- l_dummy := null;
5512: -- --
5513: -- select pet.element_name
5514: -- into l_dummy
5515: -- from pay_element_types_f pet
5516: -- where pet.element_name = l_elm_tbl(l_elm_ind)
5517: -- and pet.legislation_code = 'JP'
5518: -- and pet.effective_start_date = (
5519: -- select max(pet2.effective_start_date)

Line 5520: -- from pay_element_types_f pet2

5516: -- where pet.element_name = l_elm_tbl(l_elm_ind)
5517: -- and pet.legislation_code = 'JP'
5518: -- and pet.effective_start_date = (
5519: -- select max(pet2.effective_start_date)
5520: -- from pay_element_types_f pet2
5521: -- where pet2.element_type_id = pet.element_type_id);
5522: -- --
5523: -- if (g_dbg) then
5524: -- hr_utility.trace('fix_hr_corrupt, update elm : '||l_dummy);

Line 5556: update pay_element_types_f

5552: -- end if;
5553: --
5554: -- use bulk collect
5555: forall l_elm_ind in 1..l_elm_tbl.count
5556: update pay_element_types_f
5557: set element_name = substrb(element_name,1,80-4)||'_OBS',
5558: description = substrb(description,1,240-11)||' (Obsolete)'
5559: where element_name = l_elm_tbl(l_elm_ind)
5560: and legislation_code = 'JP';

Line 6891: FROM pay_element_types_f

6887: hr_utility.set_location(l_proc, 20);
6888:
6889: SELECT COUNT(1)
6890: INTO l_count
6891: FROM pay_element_types_f
6892: WHERE legislation_code = 'JP'
6893: AND ASCII(element_name) > 127
6894: AND description NOT LIKE '%Obsoleted';
6895: