APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_INPUT_VALUES_F

Line 17: type t_input_names_tab is table of pay_input_values_f.name%TYPE index by binary_integer;

13: procedure migrate_input_values is
14: --
15: type t_jp_input_names_tab is table of VARCHAR2(200) index by binary_integer;
16:
17: type t_input_names_tab is table of pay_input_values_f.name%TYPE index by binary_integer;
18:
19: l_jp_input_names_tab t_jp_input_names_tab;
20: l_input_names_tab t_input_names_tab;
21:

Line 1073: UPDATE pay_input_values_f

1069: hr_utility.trace('+--------------------------------------------+ ');
1070: end if;
1071: --
1072:
1073: UPDATE pay_input_values_f
1074: SET name = 'LTX'
1075: WHERE name LIKE hr_jp_standard_pkg.hextochar('E5BEB4E58F8EE7A88EE9A18D','AL32UTF8')
1076: AND legislation_code = 'JP'
1077: AND element_type_id IN (

Line 1083: UPDATE pay_input_values_f

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
1084: SET name = 'INS_PREM_ER'
1085: WHERE name LIKE hr_jp_standard_pkg.hextochar('E4BA8BE6A5ADE4B8BBE58886E4BF9DE999BAE69699','AL32UTF8')
1086: AND legislation_code = 'JP'
1087: AND element_type_id IN (

Line 1096: UPDATE pay_input_values_f

1092: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1093: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1094: AND legislation_code = 'JP' );
1095:
1096: UPDATE pay_input_values_f
1097: SET name = 'INS_PREM_EE'
1098: WHERE name LIKE hr_jp_standard_pkg.hextochar('E8A2ABE4BF9DE999BAE88085E58886E4BF9DE999BAE69699','AL32UTF8')
1099: AND legislation_code = 'JP'
1100: AND element_type_id IN (

Line 1112: UPDATE pay_input_values_f

1108:
1109:
1110: FORALL l_tab_cnt IN 1..l_jp_input_names_tab.COUNT
1111:
1112: UPDATE pay_input_values_f
1113: SET name = l_input_names_tab(l_tab_cnt)
1114: WHERE name LIKE hr_jp_standard_pkg.hextochar(l_jp_input_names_tab(l_tab_cnt),'AL32UTF8')
1115: AND legislation_code = 'JP';
1116:

Line 4890: FROM pay_input_values_f

4886: hr_utility.set_location(l_proc, 10);
4887:
4888: SELECT COUNT(1)
4889: INTO l_count
4890: FROM pay_input_values_f
4891: WHERE legislation_code = 'JP'
4892: AND ( ASCII(name) > 127 OR SUBSTR(name,1,1) = '2');
4893:
4894: IF (l_count > 0) THEN