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 2768: l_bal_names_tab(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';

2764: l_bal_names_tab(66) := 'B_YEA_SAL_DCT_LONG_TERM_NONLIFE_INS_PREM';
2765: l_bal_rep_tab(66) := 'Long Term Nonlife Insurance Premium (Salary Deduction)';
2766:
2767: l_jp_bal_names_tab(67) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68EA7E999A4E58886E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699';
2768: l_bal_names_tab(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';
2769: l_bal_rep_tab(67) := 'Individual Pension Insurance Premium (Salary Deduction)';
2770:
2771: l_jp_bal_names_tab(68) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE98791E9A18D';
2772: l_bal_names_tab(68) := 'B_YEA_AMT_AFTER_EMP_INCOME_DCT';

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

2765: l_bal_rep_tab(66) := 'Long Term Nonlife Insurance Premium (Salary Deduction)';
2766:
2767: l_jp_bal_names_tab(67) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68EA7E999A4E58886E5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699';
2768: l_bal_names_tab(67) := 'B_YEA_SAL_DCT_INDIVIDUAL_PENSION_PREM';
2769: l_bal_rep_tab(67) := 'Individual Pension Insurance Premium (Salary Deduction)';
2770:
2771: l_jp_bal_names_tab(68) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE98791E9A18D';
2772: l_bal_names_tab(68) := 'B_YEA_AMT_AFTER_EMP_INCOME_DCT';
2773: l_bal_rep_tab(68) := 'Amount after Salary Income Deduction';

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

4411:
4412: hr_utility.set_location(l_proc, 10);
4413:
4414: l_jp_table_names_tab(1) := '54EFBCBFE5B9B4EFBCBFE5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8';
4415: l_table_names_tab(1) := 'T_YEA_INDIVIDUAL_PENSION_INS_EXM';
4416: l_row_titles_tab(1) := 'ANNUAL_INS_PREM';
4417:
4418: l_jp_table_names_tab(2) := '54EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE7B5A6E4B88EE7AD89E381AEE98791E9A18DE8A1A831';
4419: l_table_names_tab(2) := 'T_YEA_AMT_AFTER_EMP_INCOME_DCT1';

Line 4735: FROM dual;

4731: ,'JP_UPGRADE_R12'
4732: ,'C'
4733: ,sysdate
4734: ,'JP'
4735: FROM dual;
4736: --
4737: END IF;
4738: Exception
4739: --