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 1079: FROM pay_element_types_f

1075: WHERE name LIKE hr_jp_standard_pkg.hextochar('E5BEB4E58F8EE7A88EE9A18D','AL32UTF8')
1076: AND legislation_code = 'JP'
1077: AND element_type_id IN (
1078: SELECT element_type_id
1079: FROM pay_element_types_f
1080: WHERE element_name LIKE hr_jp_standard_pkg.hextochar('E585B1EFBCBFE59FBAE69CACEFBCBFE4BD8FE6B091E7A88EEFBCBFE4B880E68BACE5BEB4E58F8E','AL32UTF8')
1081: AND legislation_code = 'JP' );
1082:
1083: UPDATE pay_input_values_f

Line 1089: FROM pay_element_types_f

1085: WHERE name LIKE hr_jp_standard_pkg.hextochar('E4BA8BE6A5ADE4B8BBE58886E4BF9DE999BAE69699','AL32UTF8')
1086: AND legislation_code = 'JP'
1087: AND element_type_id IN (
1088: SELECT element_type_id
1089: FROM pay_element_types_f
1090: WHERE element_name IN
1091: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1092: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1093: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))

Line 1102: FROM pay_element_types_f

1098: WHERE name LIKE hr_jp_standard_pkg.hextochar('E8A2ABE4BF9DE999BAE88085E58886E4BF9DE999BAE69699','AL32UTF8')
1099: AND legislation_code = 'JP'
1100: AND element_type_id IN (
1101: SELECT element_type_id
1102: FROM pay_element_types_f
1103: WHERE element_name IN
1104: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1105: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1106: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))

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

1139: procedure migrate_element_types is
1140: --
1141: type t_jp_element_names_tab is table of VARCHAR2(200) index by binary_integer;
1142:
1143: type t_element_names_tab is table of pay_element_types_f.element_name%TYPE index by binary_integer;
1144:
1145: type t_element_desc_tab is table of pay_element_types_f.description%TYPE index by binary_integer;
1146:
1147: type t_element_rep_tab is table of pay_element_types_f.reporting_name%TYPE index by binary_integer;

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

1141: type t_jp_element_names_tab is table of VARCHAR2(200) index by binary_integer;
1142:
1143: type t_element_names_tab is table of pay_element_types_f.element_name%TYPE index by binary_integer;
1144:
1145: type t_element_desc_tab is table of pay_element_types_f.description%TYPE index by binary_integer;
1146:
1147: type t_element_rep_tab is table of pay_element_types_f.reporting_name%TYPE index by binary_integer;
1148:
1149: l_jp_element_names_tab t_jp_element_names_tab;

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

1143: type t_element_names_tab is table of pay_element_types_f.element_name%TYPE index by binary_integer;
1144:
1145: type t_element_desc_tab is table of pay_element_types_f.description%TYPE index by binary_integer;
1146:
1147: type t_element_rep_tab is table of pay_element_types_f.reporting_name%TYPE index by binary_integer;
1148:
1149: l_jp_element_names_tab t_jp_element_names_tab;
1150: l_element_names_tab t_element_names_tab;
1151: l_element_desc_tab t_element_desc_tab;

Line 2022: UPDATE pay_element_types_f

2018: --
2019:
2020: FORALL l_tab_cnt IN 1..l_jp_element_names_tab.COUNT
2021:
2022: UPDATE pay_element_types_f
2023: SET element_name = l_element_names_tab(l_tab_cnt),
2024: description = l_element_desc_tab(l_tab_cnt),
2025: reporting_name = l_element_rep_tab(l_tab_cnt)
2026: WHERE element_name LIKE hr_jp_standard_pkg.hextochar(l_jp_element_names_tab(l_tab_cnt),'AL32UTF8')

Line 2029: UPDATE pay_element_types_f

2025: reporting_name = l_element_rep_tab(l_tab_cnt)
2026: WHERE element_name LIKE hr_jp_standard_pkg.hextochar(l_jp_element_names_tab(l_tab_cnt),'AL32UTF8')
2027: AND legislation_code = 'JP';
2028:
2029: UPDATE pay_element_types_f
2030: SET description = description || 'Obsoleted'
2031: WHERE ASCII(description) > 127
2032: AND legislation_code = 'JP';
2033:

Line 4902: FROM pay_element_types_f

4898: hr_utility.set_location(l_proc, 20);
4899:
4900: SELECT COUNT(1)
4901: INTO l_count
4902: FROM pay_element_types_f
4903: WHERE legislation_code = 'JP'
4904: AND ASCII(element_name) > 127
4905: AND description NOT LIKE '%Obsoleted';
4906: