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 1091: UPDATE pay_input_values_f

1087: hr_utility.trace('+--------------------------------------------+ ');
1088: end if;
1089: --
1090: -- update COM_LTX_LUMP_SUM_WITHHOLD_PROC elm from ITX to LTX for l_jp_input_names_tab(263) update
1091: UPDATE pay_input_values_f
1092: SET name = 'LTX'
1093: WHERE name LIKE hr_jp_standard_pkg.hextochar('E5BEB4E58F8EE7A88EE9A18D','AL32UTF8')
1094: AND legislation_code = 'JP'
1095: AND element_type_id IN (

Line 1103: UPDATE pay_input_values_f

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
1102: -- however looks this is not required if l_jp_input_names_tab(173) update to INS_PREM_ER from first..but keep this for safe
1103: UPDATE pay_input_values_f
1104: SET name = 'INS_PREM_ER'
1105: WHERE name LIKE hr_jp_standard_pkg.hextochar('E4BA8BE6A5ADE4B8BBE58886E4BF9DE999BAE69699','AL32UTF8')
1106: AND legislation_code = 'JP'
1107: AND element_type_id IN (

Line 1118: UPDATE pay_input_values_f

1114: AND legislation_code = 'JP' );
1115:
1116: -- update BON_WP_PREM_PROC (, SAL_HI_PREM_PROC, BON_HI_PREM_PROC) elm from WP_PREM_EE to INS_PREM_EE for l_jp_input_names_tab(308) update
1117: -- however looks this is not required if l_jp_input_names_tab(308) update to INS_PREM_EE from first..but keep this for safe
1118: UPDATE pay_input_values_f
1119: SET name = 'INS_PREM_EE'
1120: WHERE name LIKE hr_jp_standard_pkg.hextochar('E8A2ABE4BF9DE999BAE88085E58886E4BF9DE999BAE69699','AL32UTF8')
1121: AND legislation_code = 'JP'
1122: AND element_type_id IN (

Line 1134: UPDATE pay_input_values_f

1130:
1131:
1132: FORALL l_tab_cnt IN 1..l_jp_input_names_tab.COUNT
1133:
1134: UPDATE pay_input_values_f
1135: SET name = l_input_names_tab(l_tab_cnt)
1136: WHERE name LIKE hr_jp_standard_pkg.hextochar(l_jp_input_names_tab(l_tab_cnt),'AL32UTF8')
1137: AND legislation_code = 'JP';
1138:

Line 6879: FROM pay_input_values_f

6875: hr_utility.set_location(l_proc,10);
6876: --
6877: SELECT COUNT(1)
6878: INTO l_count
6879: FROM pay_input_values_f
6880: WHERE legislation_code = 'JP'
6881: AND ( ASCII(name) > 127 OR SUBSTR(name,1,1) = '2');
6882:
6883: IF (l_count > 0) THEN