APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_SETS

Line 3185: type t_ele_set_names_tab is table of pay_element_sets.element_set_name%TYPE index by binary_integer;

3181: procedure migrate_element_sets is
3182: --
3183: type t_jp_ele_set_names_tab is table of VARCHAR2(50) index by binary_integer;
3184:
3185: type t_ele_set_names_tab is table of pay_element_sets.element_set_name%TYPE index by binary_integer;
3186:
3187: l_jp_ele_set_names_tab t_jp_ele_set_names_tab;
3188: l_ele_set_names_tab t_ele_set_names_tab;
3189:

Line 3219: UPDATE pay_element_sets

3215: --
3216:
3217: FORALL l_tab_cnt IN 1..l_jp_ele_set_names_tab.COUNT
3218:
3219: UPDATE pay_element_sets
3220: SET element_set_name = l_ele_set_names_tab(l_tab_cnt)
3221: WHERE element_set_name LIKE hr_jp_standard_pkg.hextochar(l_jp_ele_set_names_tab(l_tab_cnt),'AL32UTF8')
3222: AND legislation_code = 'JP';
3223:

Line 4952: FROM pay_element_sets

4948: hr_utility.set_location(l_proc, 60);
4949:
4950: SELECT COUNT(1)
4951: INTO l_count
4952: FROM pay_element_sets
4953: WHERE legislation_code = 'JP'
4954: AND ASCII(element_set_name) > 127;
4955:
4956: IF (l_count > 0) THEN