699: -- Package initialize routine.
700: --
701: -- Used to determine Income Tax Category.
702: --
703: g_id.SAL_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
704: 'SAL_ITX',
705: 'ITX_TYPE',NULL,'JP');
706: g_id.SAL_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
707: 'SAL_ITX_NRES',
702: --
703: g_id.SAL_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
704: 'SAL_ITX',
705: 'ITX_TYPE',NULL,'JP');
706: g_id.SAL_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
707: 'SAL_ITX_NRES',
708: 'Pay Value',NULL,'JP');
709: g_id.BON_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
710: 'BON_ITX',
705: 'ITX_TYPE',NULL,'JP');
706: g_id.SAL_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
707: 'SAL_ITX_NRES',
708: 'Pay Value',NULL,'JP');
709: g_id.BON_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
710: 'BON_ITX',
711: 'ITX_TYPE',NULL,'JP');
712: g_id.BON_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
713: 'BON_ITX_NRES',
708: 'Pay Value',NULL,'JP');
709: g_id.BON_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
710: 'BON_ITX',
711: 'ITX_TYPE',NULL,'JP');
712: g_id.BON_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
713: 'BON_ITX_NRES',
714: 'Pay Value',NULL,'JP');
715: g_id.SP_BON_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
716: 'SPB_ITX',
711: 'ITX_TYPE',NULL,'JP');
712: g_id.BON_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
713: 'BON_ITX_NRES',
714: 'Pay Value',NULL,'JP');
715: g_id.SP_BON_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
716: 'SPB_ITX',
717: 'ITX_TYPE',NULL,'JP');
718: g_id.SP_BON_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
719: 'SPB_ITX_NRES',
714: 'Pay Value',NULL,'JP');
715: g_id.SP_BON_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
716: 'SPB_ITX',
717: 'ITX_TYPE',NULL,'JP');
718: g_id.SP_BON_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
719: 'SPB_ITX_NRES',
720: 'Pay Value',NULL,'JP');
721: g_id.YEA_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
722: 'YEA_AMT_AFTER_EMP_INCOME_DCT_RSLT',
717: 'ITX_TYPE',NULL,'JP');
718: g_id.SP_BON_NR_ITAX_IV := hr_jp_id_pkg.input_value_id(
719: 'SPB_ITX_NRES',
720: 'Pay Value',NULL,'JP');
721: g_id.YEA_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
722: 'YEA_AMT_AFTER_EMP_INCOME_DCT_RSLT',
723: 'ITX_TYPE',NULL,'JP');
724: g_id.YEA_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
725: 'YEA_AMT_AFTER_EMP_INCOME_DCT_RSLT',
720: 'Pay Value',NULL,'JP');
721: g_id.YEA_ITAX_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
722: 'YEA_AMT_AFTER_EMP_INCOME_DCT_RSLT',
723: 'ITX_TYPE',NULL,'JP');
724: g_id.YEA_CATEGORY_IV := hr_jp_id_pkg.input_value_id(
725: 'YEA_AMT_AFTER_EMP_INCOME_DCT_RSLT',
726: 'INCLUDE_FLAG',NULL,'JP');
727: --
728: -- Currently there's no exact way to distinguish Resident or Nonresident
731: -- Pay attention Termination Payment is not included.
732: --
733: -- Only Resident balances except for allowance balance.
734: --
735: g_defined_balance_lst(1).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_ERN', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
736: g_defined_balance_lst(2).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_MONEY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
737: g_defined_balance_lst(3).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_KIND', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
738: g_defined_balance_lst(4).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_SAL_DCT_SI_PREM','_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
739: g_defined_balance_lst(5).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_WITHHOLD_ITX', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
732: --
733: -- Only Resident balances except for allowance balance.
734: --
735: g_defined_balance_lst(1).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_ERN', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
736: g_defined_balance_lst(2).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_MONEY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
737: g_defined_balance_lst(3).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_KIND', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
738: g_defined_balance_lst(4).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_SAL_DCT_SI_PREM','_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
739: g_defined_balance_lst(5).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_WITHHOLD_ITX', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
740: g_defined_balance_lst(6).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TAX_PAY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
733: -- Only Resident balances except for allowance balance.
734: --
735: g_defined_balance_lst(1).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_ERN', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
736: g_defined_balance_lst(2).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_MONEY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
737: g_defined_balance_lst(3).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_KIND', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
738: g_defined_balance_lst(4).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_SAL_DCT_SI_PREM','_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
739: g_defined_balance_lst(5).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_WITHHOLD_ITX', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
740: g_defined_balance_lst(6).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TAX_PAY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
741: END pay_jp_soe_pkg;
734: --
735: g_defined_balance_lst(1).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_ERN', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
736: g_defined_balance_lst(2).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_MONEY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
737: g_defined_balance_lst(3).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_KIND', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
738: g_defined_balance_lst(4).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_SAL_DCT_SI_PREM','_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
739: g_defined_balance_lst(5).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_WITHHOLD_ITX', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
740: g_defined_balance_lst(6).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TAX_PAY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
741: END pay_jp_soe_pkg;
735: g_defined_balance_lst(1).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_ERN', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
736: g_defined_balance_lst(2).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_MONEY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
737: g_defined_balance_lst(3).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_KIND', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
738: g_defined_balance_lst(4).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_SAL_DCT_SI_PREM','_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
739: g_defined_balance_lst(5).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_WITHHOLD_ITX', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
740: g_defined_balance_lst(6).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TAX_PAY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
741: END pay_jp_soe_pkg;
736: g_defined_balance_lst(2).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_MONEY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
737: g_defined_balance_lst(3).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TXBL_ERN_KIND', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
738: g_defined_balance_lst(4).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_SAL_DCT_SI_PREM','_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
739: g_defined_balance_lst(5).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_WITHHOLD_ITX', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
740: g_defined_balance_lst(6).defined_balance_id := hr_jp_id_pkg.defined_balance_id('B_YEA_TAX_PAY', '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01', null, 'JP');
741: END pay_jp_soe_pkg;