APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_MONETARY_UNITS

Line 3816: type t_monetary_name_tab is table of pay_monetary_units.monetary_unit_name%TYPE index by binary_integer;

3812: procedure migrate_monetary_units is
3813: --
3814: type t_jp_monetary_name_tab is table of VARCHAR2(50) index by binary_integer;
3815:
3816: type t_monetary_name_tab is table of pay_monetary_units.monetary_unit_name%TYPE index by binary_integer;
3817:
3818: l_jp_monetary_name_tab t_jp_monetary_name_tab;
3819: l_monetary_name_tab t_monetary_name_tab;
3820:

Line 3851: UPDATE pay_monetary_units

3847: --
3848:
3849: FORALL l_tab_cnt IN 1..l_jp_monetary_name_tab.COUNT
3850:
3851: UPDATE pay_monetary_units
3852: SET monetary_unit_name = l_monetary_name_tab(l_tab_cnt)
3853: WHERE monetary_unit_name LIKE hr_jp_standard_pkg.hextochar(l_jp_monetary_name_tab(l_tab_cnt),'AL32UTF8')
3854: AND legislation_code = 'JP';
3855:

Line 4990: FROM pay_monetary_units

4986: hr_utility.set_location(l_proc, 90);
4987:
4988: SELECT COUNT(1)
4989: INTO l_count
4990: FROM pay_monetary_units
4991: WHERE legislation_code = 'JP'
4992: AND ASCII(SUBSTR(monetary_unit_name,LENGTH(monetary_unit_name),1)) > 127;
4993:
4994: IF (l_count > 0) THEN