DBA Data[Home] [Help]

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on DUAL

Line 146: l_input_names_tab(39) := 'SAL_DCT_INDIVIDUAL_PENSION_PREM';

142: l_jp_input_names_tab(38) := 'E7B5A6E4B88EE9968BE5A78BE69C88';
143: l_input_names_tab(38) := 'PAYROLL_START_MTH';
144:
145: l_jp_input_names_tab(39) := 'E7B5A6E4B88EE68EA7E999A4E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699';
146: l_input_names_tab(39) := 'SAL_DCT_INDIVIDUAL_PENSION_PREM';
147:
148: l_jp_input_names_tab(40) := 'E7B5A6E4B88EE68EA7E999A4E7A4BEE4BC9AE4BF9DE999BAE69699';
149: l_input_names_tab(40) := 'SAL_DCT_SI_PREM';
150:

Line 311: l_input_names_tab(94) := 'INDIVIDUAL_PENSION_PREM';

307: l_jp_input_names_tab(93) := 'E78FBEE789A9E58886E99D9EE8AAB2E7A88EE5AFBEE8B1A1E9A18D';
308: l_input_names_tab(93) := 'NTXBL_ERN_KIND';
309:
310: l_jp_input_names_tab(94) := 'E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699';
311: l_input_names_tab(94) := 'INDIVIDUAL_PENSION_PREM';
312:
313: l_jp_input_names_tab(95) := 'E5808BE4BABAE795AAE58FB7';
314: l_input_names_tab(95) := 'PERSONAL_NUM';
315:

Line 1041: l_input_names_tab(337) := 'INDIVIDUAL_PENSION_PREM';

1037: l_jp_input_names_tab(336) := '47656E6572616C204C69666520496E73205072656D';
1038: l_input_names_tab(336) := 'GEN_LIFE_INS_PREM';
1039:
1040: l_jp_input_names_tab(337) := '496E646976696475616C2050656E73205072656D';
1041: l_input_names_tab(337) := 'INDIVIDUAL_PENSION_PREM';
1042:
1043: l_jp_input_names_tab(338) := '4C6F6E67205465726D204E6F6E6C69666520496E73205072656D';
1044: l_input_names_tab(338) := 'LONG_TERM_NONLIFE_INS_PREM';
1045:

Line 1072: l_input_names_tab(347) := 'INDIVIDUAL_PENSION_PREM_2012';

1068: l_jp_input_names_tab(346) := 'E4BB8BE8ADB7E58CBBE79982E4BF9DE999BAE69699EFBCBF32303132E5B9B4E4BBA5E9998D';
1069: l_input_names_tab(346) := 'CARE_MED_INS_PREM_2012';
1070:
1071: l_jp_input_names_tab(347) := 'E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699EFBCBF32303132E5B9B4E4BBA5E9998D';
1072: l_input_names_tab(347) := 'INDIVIDUAL_PENSION_PREM_2012';
1073:
1074: l_jp_input_names_tab(348) := 'E7B5A6E4B88EE68EA7E999A4E7949FE591BDE4BF9DE999BAEFBCBF32303132E5B9B4E4BBA5E9998D';
1075: l_input_names_tab(348) := 'SAL_DCT_GEN_LIFE_INS_PREM_2012';
1076:

Line 2790: l_bal_names_tab(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';

2786: l_bal_names_tab(66) := 'B_YEA_SAL_DCT_LONG_TERM_NONLIFE_INS_PREM';
2787: l_bal_rep_tab(66) := 'Long Term Nonlife Insurance Premium (Salary Deduction)';
2788:
2789: l_jp_bal_names_tab(67) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68EA7E999A4E58886E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699';
2790: l_bal_names_tab(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';
2791: l_bal_rep_tab(67) := 'Individual Pension Insurance Premium (Salary Deduction)';
2792:
2793: l_jp_bal_names_tab(68) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE98791E9A18D';
2794: l_bal_names_tab(68) := 'B_YEA_AMT_AFTER_EMP_INCOME_DCT';

Line 2791: l_bal_rep_tab(67) := 'Individual Pension Insurance Premium (Salary Deduction)';

2787: l_bal_rep_tab(66) := 'Long Term Nonlife Insurance Premium (Salary Deduction)';
2788:
2789: l_jp_bal_names_tab(67) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68EA7E999A4E58886E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699';
2790: l_bal_names_tab(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';
2791: l_bal_rep_tab(67) := 'Individual Pension Insurance Premium (Salary Deduction)';
2792:
2793: l_jp_bal_names_tab(68) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE98791E9A18D';
2794: l_bal_names_tab(68) := 'B_YEA_AMT_AFTER_EMP_INCOME_DCT';
2795: l_bal_rep_tab(68) := 'Amount after Salary Income Deduction';

Line 4399: l_row_names_tab(38) := 'INDIVIDUAL_PENSION_INS_EXM_2012';

4395: l_jp_row_names_tab(37) := 'E4B880E888ACE7949FE591BDE4BF9DE999BAE69699E68EA7E999A4EFBCBF32303132E5B9B4E4BBA5E9998D';
4396: l_row_names_tab(37) := 'GEN_LIFE_INS_EXM_2012';
4397:
4398: l_jp_row_names_tab(38) := 'E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699E68EA7E999A4EFBCBF32303132E5B9B4E4BBA5E9998D';
4399: l_row_names_tab(38) := 'INDIVIDUAL_PENSION_INS_EXM_2012';
4400:
4401: l_jp_row_names_tab(39) := 'E7949FE591BDE4BF9DE999BAE69699E68EA7E999A4EFBCBF32303132E5B9B4E4BBA5E9998D';
4402: l_row_names_tab(39) := 'LIFE_INS_EXM_2012';
4403:

Line 4463: l_table_names_tab(1) := 'T_YEA_INDIVIDUAL_PENSION_INS_EXM';

4459:
4460: hr_utility.set_location(l_proc, 10);
4461:
4462: l_jp_table_names_tab(1) := '54EFBCBFE5B9B4EFBCBFE5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8';
4463: l_table_names_tab(1) := 'T_YEA_INDIVIDUAL_PENSION_INS_EXM';
4464: l_row_titles_tab(1) := 'ANNUAL_INS_PREM';
4465:
4466: l_jp_table_names_tab(2) := '54EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE7B5A6E4B88EE7AD89E381AEE98791E9A18DE8A1A831';
4467: l_table_names_tab(2) := 'T_YEA_AMT_AFTER_EMP_INCOME_DCT1';

Line 4841: FROM dual;

4837: ,'C'
4838: ,sysdate
4839: ,'JP'
4840: ,'9737155,12566233'
4841: FROM dual;
4842: --
4843: else
4844: --
4845: if instr(nvl(rec_del_dtls.process_type,'X'),'9737155') = 0 then

Line 5820: l_bal_tbl(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';

5816: l_bal_tbl(63) := 'B_COM_HI_PREM';
5817: l_bal_tbl(64) := 'B_YEA_WITHHOLD_ITX';
5818: l_bal_tbl(65) := 'B_YEA_SAL_DCT_LIFE_INS_PREM';
5819: l_bal_tbl(66) := 'B_YEA_SAL_DCT_LONG_TERM_NONLIFE_INS_PREM';
5820: l_bal_tbl(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';
5821: l_bal_tbl(68) := 'B_YEA_AMT_AFTER_EMP_INCOME_DCT';
5822: l_bal_tbl(69) := 'B_YEA_SAL_DCT_SHORT_TERM_NONLIFE_INS_PREM';
5823: l_bal_tbl(70) := 'B_YEA_TXBL_ERN_MONEY';
5824: l_bal_tbl(71) := 'B_YEA_TXBL_ERN_KIND';

Line 6535: l_udt_tbl(1) := 'T_YEA_INDIVIDUAL_PENSION_INS_EXM';

6531: if l_udt_cnt > 0 then
6532: --
6533: -- target only udt which are listed in rename by pay_jp_data_migration_pkg.migrate_user_tables
6534: --
6535: l_udt_tbl(1) := 'T_YEA_INDIVIDUAL_PENSION_INS_EXM';
6536: l_udt_tbl(2) := 'T_YEA_AMT_AFTER_EMP_INCOME_DCT1';
6537: l_udt_tbl(3) := 'T_YEA_AMT_AFTER_EMP_INCOME_DCT2';
6538: l_udt_tbl(4) := 'T_YEA_LIFE_INS_EXM';
6539: l_udt_tbl(5) := 'T_YEA_LONG_NONLIFE_INS_EXM';