DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 8: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,

4: g_archive_default_flag varchar2(1);
5: g_copy_archive_pact_id number;
6: --
7: type t_li_info_rec is record(
8: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
9: aei_object_version_number per_assignment_extra_info.object_version_number%type,
10: info_type hr_organization_information.org_information_context%type,
11: ins_class per_assignment_extra_info.aei_information1%type,
12: ins_comp_code per_assignment_extra_info.aei_information2%type,

Line 9: aei_object_version_number per_assignment_extra_info.object_version_number%type,

5: g_copy_archive_pact_id number;
6: --
7: type t_li_info_rec is record(
8: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
9: aei_object_version_number per_assignment_extra_info.object_version_number%type,
10: info_type hr_organization_information.org_information_context%type,
11: ins_class per_assignment_extra_info.aei_information1%type,
12: ins_comp_code per_assignment_extra_info.aei_information2%type,
13: ins_class_old_new varchar2(20),

Line 11: ins_class per_assignment_extra_info.aei_information1%type,

7: type t_li_info_rec is record(
8: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
9: aei_object_version_number per_assignment_extra_info.object_version_number%type,
10: info_type hr_organization_information.org_information_context%type,
11: ins_class per_assignment_extra_info.aei_information1%type,
12: ins_comp_code per_assignment_extra_info.aei_information2%type,
13: ins_class_old_new varchar2(20),
14: ins_comp_name hr_organization_information.org_information2%type,
15: calc_prem_ff hr_organization_information.org_information3%type,

Line 12: ins_comp_code per_assignment_extra_info.aei_information2%type,

8: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
9: aei_object_version_number per_assignment_extra_info.object_version_number%type,
10: info_type hr_organization_information.org_information_context%type,
11: ins_class per_assignment_extra_info.aei_information1%type,
12: ins_comp_code per_assignment_extra_info.aei_information2%type,
13: ins_class_old_new varchar2(20),
14: ins_comp_name hr_organization_information.org_information2%type,
15: calc_prem_ff hr_organization_information.org_information3%type,
16: lig_prem_bal hr_organization_information.org_information4%type,

Line 27: ins_type per_assignment_extra_info.aei_information5%type,

23: cmi_prem_mth_ele hr_organization_information.org_information8%type,
24: cmi_prem_bon_ele hr_organization_information.org_information9%type,
25: start_date date,
26: end_date date,
27: ins_type per_assignment_extra_info.aei_information5%type,
28: ins_period_start_date date,
29: ins_period per_assignment_extra_info.aei_information6%type,
30: contractor_name per_assignment_extra_info.aei_information7%type,
31: beneficiary_name per_assignment_extra_info.aei_information8%type,

Line 29: ins_period per_assignment_extra_info.aei_information6%type,

25: start_date date,
26: end_date date,
27: ins_type per_assignment_extra_info.aei_information5%type,
28: ins_period_start_date date,
29: ins_period per_assignment_extra_info.aei_information6%type,
30: contractor_name per_assignment_extra_info.aei_information7%type,
31: beneficiary_name per_assignment_extra_info.aei_information8%type,
32: beneficiary_relship per_assignment_extra_info.aei_information9%type,
33: linc_prem number);

Line 30: contractor_name per_assignment_extra_info.aei_information7%type,

26: end_date date,
27: ins_type per_assignment_extra_info.aei_information5%type,
28: ins_period_start_date date,
29: ins_period per_assignment_extra_info.aei_information6%type,
30: contractor_name per_assignment_extra_info.aei_information7%type,
31: beneficiary_name per_assignment_extra_info.aei_information8%type,
32: beneficiary_relship per_assignment_extra_info.aei_information9%type,
33: linc_prem number);
34: --

Line 31: beneficiary_name per_assignment_extra_info.aei_information8%type,

27: ins_type per_assignment_extra_info.aei_information5%type,
28: ins_period_start_date date,
29: ins_period per_assignment_extra_info.aei_information6%type,
30: contractor_name per_assignment_extra_info.aei_information7%type,
31: beneficiary_name per_assignment_extra_info.aei_information8%type,
32: beneficiary_relship per_assignment_extra_info.aei_information9%type,
33: linc_prem number);
34: --
35: type t_ai_info_rec is record(

Line 32: beneficiary_relship per_assignment_extra_info.aei_information9%type,

28: ins_period_start_date date,
29: ins_period per_assignment_extra_info.aei_information6%type,
30: contractor_name per_assignment_extra_info.aei_information7%type,
31: beneficiary_name per_assignment_extra_info.aei_information8%type,
32: beneficiary_relship per_assignment_extra_info.aei_information9%type,
33: linc_prem number);
34: --
35: type t_ai_info_rec is record(
36: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,

Line 36: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,

32: beneficiary_relship per_assignment_extra_info.aei_information9%type,
33: linc_prem number);
34: --
35: type t_ai_info_rec is record(
36: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
37: aei_object_version_number per_assignment_extra_info.object_version_number%type,
38: info_type hr_organization_information.org_information_context%type,
39: ins_class per_assignment_extra_info.aei_information13%type,
40: ins_term_type per_assignment_extra_info.aei_information1%type,

Line 37: aei_object_version_number per_assignment_extra_info.object_version_number%type,

33: linc_prem number);
34: --
35: type t_ai_info_rec is record(
36: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
37: aei_object_version_number per_assignment_extra_info.object_version_number%type,
38: info_type hr_organization_information.org_information_context%type,
39: ins_class per_assignment_extra_info.aei_information13%type,
40: ins_term_type per_assignment_extra_info.aei_information1%type,
41: ins_comp_code per_assignment_extra_info.aei_information2%type,

Line 39: ins_class per_assignment_extra_info.aei_information13%type,

35: type t_ai_info_rec is record(
36: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
37: aei_object_version_number per_assignment_extra_info.object_version_number%type,
38: info_type hr_organization_information.org_information_context%type,
39: ins_class per_assignment_extra_info.aei_information13%type,
40: ins_term_type per_assignment_extra_info.aei_information1%type,
41: ins_comp_code per_assignment_extra_info.aei_information2%type,
42: ins_comp_name hr_organization_information.org_information2%type,
43: calc_prem_ff hr_organization_information.org_information3%type,

Line 40: ins_term_type per_assignment_extra_info.aei_information1%type,

36: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
37: aei_object_version_number per_assignment_extra_info.object_version_number%type,
38: info_type hr_organization_information.org_information_context%type,
39: ins_class per_assignment_extra_info.aei_information13%type,
40: ins_term_type per_assignment_extra_info.aei_information1%type,
41: ins_comp_code per_assignment_extra_info.aei_information2%type,
42: ins_comp_name hr_organization_information.org_information2%type,
43: calc_prem_ff hr_organization_information.org_information3%type,
44: eqi_prem_bal hr_organization_information.org_information4%type,

Line 41: ins_comp_code per_assignment_extra_info.aei_information2%type,

37: aei_object_version_number per_assignment_extra_info.object_version_number%type,
38: info_type hr_organization_information.org_information_context%type,
39: ins_class per_assignment_extra_info.aei_information13%type,
40: ins_term_type per_assignment_extra_info.aei_information1%type,
41: ins_comp_code per_assignment_extra_info.aei_information2%type,
42: ins_comp_name hr_organization_information.org_information2%type,
43: calc_prem_ff hr_organization_information.org_information3%type,
44: eqi_prem_bal hr_organization_information.org_information4%type,
45: eqi_prem_mth_ele hr_organization_information.org_information5%type,

Line 52: ins_type per_assignment_extra_info.aei_information5%type,

48: ai_prem_mth_ele hr_organization_information.org_information8%type,
49: ai_prem_bon_ele hr_organization_information.org_information9%type,
50: start_date date,
51: end_date date,
52: ins_type per_assignment_extra_info.aei_information5%type,
53: ins_period per_assignment_extra_info.aei_information6%type,
54: contractor_name per_assignment_extra_info.aei_information7%type,
55: beneficiary_name per_assignment_extra_info.aei_information8%type,
56: beneficiary_relship per_assignment_extra_info.aei_information9%type,

Line 53: ins_period per_assignment_extra_info.aei_information6%type,

49: ai_prem_bon_ele hr_organization_information.org_information9%type,
50: start_date date,
51: end_date date,
52: ins_type per_assignment_extra_info.aei_information5%type,
53: ins_period per_assignment_extra_info.aei_information6%type,
54: contractor_name per_assignment_extra_info.aei_information7%type,
55: beneficiary_name per_assignment_extra_info.aei_information8%type,
56: beneficiary_relship per_assignment_extra_info.aei_information9%type,
57: maturity_repayment per_assignment_extra_info.aei_information10%type,

Line 54: contractor_name per_assignment_extra_info.aei_information7%type,

50: start_date date,
51: end_date date,
52: ins_type per_assignment_extra_info.aei_information5%type,
53: ins_period per_assignment_extra_info.aei_information6%type,
54: contractor_name per_assignment_extra_info.aei_information7%type,
55: beneficiary_name per_assignment_extra_info.aei_information8%type,
56: beneficiary_relship per_assignment_extra_info.aei_information9%type,
57: maturity_repayment per_assignment_extra_info.aei_information10%type,
58: annual_prem number);

Line 55: beneficiary_name per_assignment_extra_info.aei_information8%type,

51: end_date date,
52: ins_type per_assignment_extra_info.aei_information5%type,
53: ins_period per_assignment_extra_info.aei_information6%type,
54: contractor_name per_assignment_extra_info.aei_information7%type,
55: beneficiary_name per_assignment_extra_info.aei_information8%type,
56: beneficiary_relship per_assignment_extra_info.aei_information9%type,
57: maturity_repayment per_assignment_extra_info.aei_information10%type,
58: annual_prem number);
59: --

Line 56: beneficiary_relship per_assignment_extra_info.aei_information9%type,

52: ins_type per_assignment_extra_info.aei_information5%type,
53: ins_period per_assignment_extra_info.aei_information6%type,
54: contractor_name per_assignment_extra_info.aei_information7%type,
55: beneficiary_name per_assignment_extra_info.aei_information8%type,
56: beneficiary_relship per_assignment_extra_info.aei_information9%type,
57: maturity_repayment per_assignment_extra_info.aei_information10%type,
58: annual_prem number);
59: --
60: type t_spouse_rec is record(

Line 57: maturity_repayment per_assignment_extra_info.aei_information10%type,

53: ins_period per_assignment_extra_info.aei_information6%type,
54: contractor_name per_assignment_extra_info.aei_information7%type,
55: beneficiary_name per_assignment_extra_info.aei_information8%type,
56: beneficiary_relship per_assignment_extra_info.aei_information9%type,
57: maturity_repayment per_assignment_extra_info.aei_information10%type,
58: annual_prem number);
59: --
60: type t_spouse_rec is record(
61: spouse_type varchar2(60),