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_comp_name hr_organization_information.org_information2%type,

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_comp_name hr_organization_information.org_information2%type,
14: calc_prem_ff hr_organization_information.org_information3%type,
15: lig_prem_bal hr_organization_information.org_information4%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_comp_name hr_organization_information.org_information2%type,
14: calc_prem_ff hr_organization_information.org_information3%type,
15: lig_prem_bal hr_organization_information.org_information4%type,
16: lig_prem_mth_ele hr_organization_information.org_information5%type,

Line 23: ins_type per_assignment_extra_info.aei_information5%type,

19: lip_prem_mth_ele hr_organization_information.org_information8%type,
20: lip_prem_bon_ele hr_organization_information.org_information9%type,
21: start_date date,
22: end_date date,
23: ins_type per_assignment_extra_info.aei_information5%type,
24: ins_period_start_date date,
25: ins_period per_assignment_extra_info.aei_information6%type,
26: contractor_name per_assignment_extra_info.aei_information7%type,
27: beneficiary_name per_assignment_extra_info.aei_information8%type,

Line 25: ins_period per_assignment_extra_info.aei_information6%type,

21: start_date date,
22: end_date date,
23: ins_type per_assignment_extra_info.aei_information5%type,
24: ins_period_start_date date,
25: ins_period per_assignment_extra_info.aei_information6%type,
26: contractor_name per_assignment_extra_info.aei_information7%type,
27: beneficiary_name per_assignment_extra_info.aei_information8%type,
28: beneficiary_relship per_assignment_extra_info.aei_information9%type,
29: linc_prem number);

Line 26: contractor_name per_assignment_extra_info.aei_information7%type,

22: end_date date,
23: ins_type per_assignment_extra_info.aei_information5%type,
24: ins_period_start_date date,
25: ins_period per_assignment_extra_info.aei_information6%type,
26: contractor_name per_assignment_extra_info.aei_information7%type,
27: beneficiary_name per_assignment_extra_info.aei_information8%type,
28: beneficiary_relship per_assignment_extra_info.aei_information9%type,
29: linc_prem number);
30: --

Line 27: beneficiary_name per_assignment_extra_info.aei_information8%type,

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

Line 28: beneficiary_relship per_assignment_extra_info.aei_information9%type,

24: ins_period_start_date date,
25: ins_period per_assignment_extra_info.aei_information6%type,
26: contractor_name per_assignment_extra_info.aei_information7%type,
27: beneficiary_name per_assignment_extra_info.aei_information8%type,
28: beneficiary_relship per_assignment_extra_info.aei_information9%type,
29: linc_prem number);
30: --
31: type t_ai_info_rec is record(
32: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,

Line 32: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,

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

Line 33: aei_object_version_number per_assignment_extra_info.object_version_number%type,

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

Line 35: ins_class per_assignment_extra_info.aei_information13%type,

31: type t_ai_info_rec is record(
32: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
33: aei_object_version_number per_assignment_extra_info.object_version_number%type,
34: info_type hr_organization_information.org_information_context%type,
35: ins_class per_assignment_extra_info.aei_information13%type,
36: ins_term_type per_assignment_extra_info.aei_information1%type,
37: ins_comp_code per_assignment_extra_info.aei_information2%type,
38: ins_comp_name hr_organization_information.org_information2%type,
39: calc_prem_ff hr_organization_information.org_information3%type,

Line 36: ins_term_type per_assignment_extra_info.aei_information1%type,

32: assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
33: aei_object_version_number per_assignment_extra_info.object_version_number%type,
34: info_type hr_organization_information.org_information_context%type,
35: ins_class per_assignment_extra_info.aei_information13%type,
36: ins_term_type per_assignment_extra_info.aei_information1%type,
37: ins_comp_code per_assignment_extra_info.aei_information2%type,
38: ins_comp_name hr_organization_information.org_information2%type,
39: calc_prem_ff hr_organization_information.org_information3%type,
40: eqi_prem_bal hr_organization_information.org_information4%type,

Line 37: ins_comp_code per_assignment_extra_info.aei_information2%type,

33: aei_object_version_number per_assignment_extra_info.object_version_number%type,
34: info_type hr_organization_information.org_information_context%type,
35: ins_class per_assignment_extra_info.aei_information13%type,
36: ins_term_type per_assignment_extra_info.aei_information1%type,
37: ins_comp_code per_assignment_extra_info.aei_information2%type,
38: ins_comp_name hr_organization_information.org_information2%type,
39: calc_prem_ff hr_organization_information.org_information3%type,
40: eqi_prem_bal hr_organization_information.org_information4%type,
41: eqi_prem_mth_ele hr_organization_information.org_information5%type,

Line 48: ins_type per_assignment_extra_info.aei_information5%type,

44: ai_prem_mth_ele hr_organization_information.org_information8%type,
45: ai_prem_bon_ele hr_organization_information.org_information9%type,
46: start_date date,
47: end_date date,
48: ins_type per_assignment_extra_info.aei_information5%type,
49: ins_period per_assignment_extra_info.aei_information6%type,
50: contractor_name per_assignment_extra_info.aei_information7%type,
51: beneficiary_name per_assignment_extra_info.aei_information8%type,
52: beneficiary_relship per_assignment_extra_info.aei_information9%type,

Line 49: ins_period per_assignment_extra_info.aei_information6%type,

45: ai_prem_bon_ele hr_organization_information.org_information9%type,
46: start_date date,
47: end_date date,
48: ins_type per_assignment_extra_info.aei_information5%type,
49: ins_period per_assignment_extra_info.aei_information6%type,
50: contractor_name per_assignment_extra_info.aei_information7%type,
51: beneficiary_name per_assignment_extra_info.aei_information8%type,
52: beneficiary_relship per_assignment_extra_info.aei_information9%type,
53: maturity_repayment per_assignment_extra_info.aei_information10%type,

Line 50: contractor_name per_assignment_extra_info.aei_information7%type,

46: start_date date,
47: end_date date,
48: ins_type per_assignment_extra_info.aei_information5%type,
49: ins_period per_assignment_extra_info.aei_information6%type,
50: contractor_name per_assignment_extra_info.aei_information7%type,
51: beneficiary_name per_assignment_extra_info.aei_information8%type,
52: beneficiary_relship per_assignment_extra_info.aei_information9%type,
53: maturity_repayment per_assignment_extra_info.aei_information10%type,
54: annual_prem number);

Line 51: beneficiary_name per_assignment_extra_info.aei_information8%type,

47: end_date date,
48: ins_type per_assignment_extra_info.aei_information5%type,
49: ins_period per_assignment_extra_info.aei_information6%type,
50: contractor_name per_assignment_extra_info.aei_information7%type,
51: beneficiary_name per_assignment_extra_info.aei_information8%type,
52: beneficiary_relship per_assignment_extra_info.aei_information9%type,
53: maturity_repayment per_assignment_extra_info.aei_information10%type,
54: annual_prem number);
55: --

Line 52: beneficiary_relship per_assignment_extra_info.aei_information9%type,

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

Line 53: maturity_repayment per_assignment_extra_info.aei_information10%type,

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