18: -- SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
19: -- SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
20:
21: TYPE deal_rec_type is record (
22: chr_id okl_k_headers_full_v.id%type,
23: chr_contract_number okl_k_headers_full_v.contract_number%type,
24: chr_description okl_k_headers_full_v.description%type,
25: vers_version VARCHAR2(30),
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
19: -- SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
20:
21: TYPE deal_rec_type is record (
22: chr_id okl_k_headers_full_v.id%type,
23: chr_contract_number okl_k_headers_full_v.contract_number%type,
24: chr_description okl_k_headers_full_v.description%type,
25: vers_version VARCHAR2(30),
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
20:
21: TYPE deal_rec_type is record (
22: chr_id okl_k_headers_full_v.id%type,
23: chr_contract_number okl_k_headers_full_v.contract_number%type,
24: chr_description okl_k_headers_full_v.description%type,
25: vers_version VARCHAR2(30),
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
22: chr_id okl_k_headers_full_v.id%type,
23: chr_contract_number okl_k_headers_full_v.contract_number%type,
24: chr_description okl_k_headers_full_v.description%type,
25: vers_version VARCHAR2(30),
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
23: chr_contract_number okl_k_headers_full_v.contract_number%type,
24: chr_description okl_k_headers_full_v.description%type,
25: vers_version VARCHAR2(30),
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
24: chr_description okl_k_headers_full_v.description%type,
25: vers_version VARCHAR2(30),
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
25: vers_version VARCHAR2(30),
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
26: chr_sts_code okl_k_headers_full_v.sts_code%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
27: chr_start_date okl_k_headers_full_v.start_date%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
28: chr_end_date okl_k_headers_full_v.end_date%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
29: khr_term_duration okl_k_headers_full_v.term_duration%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
30: chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
31: chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
32: chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
33: khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
34: khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
35: khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
36: khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
37: khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
45: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
38: khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
45: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
46: mla_contract_number okl_k_headers_full_v.contract_number%type,
39: chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
45: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
46: mla_contract_number okl_k_headers_full_v.contract_number%type,
47: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
40: chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
45: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
46: mla_contract_number okl_k_headers_full_v.contract_number%type,
47: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
48: mla_gvr_id okl_k_headers_full_v.id%type,
41: khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
45: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
46: mla_contract_number okl_k_headers_full_v.contract_number%type,
47: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
48: mla_gvr_id okl_k_headers_full_v.id%type,
49: cust_id okc_k_party_roles_v.id%type,
42: khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type,
43: khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
45: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
46: mla_contract_number okl_k_headers_full_v.contract_number%type,
47: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
48: mla_gvr_id okl_k_headers_full_v.id%type,
49: cust_id okc_k_party_roles_v.id%type,
50: cust_object1_id1 okc_k_party_roles_v.object1_id1%type,
44: khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type,
45: khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type,
46: mla_contract_number okl_k_headers_full_v.contract_number%type,
47: mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type,
48: mla_gvr_id okl_k_headers_full_v.id%type,
49: cust_id okc_k_party_roles_v.id%type,
50: cust_object1_id1 okc_k_party_roles_v.object1_id1%type,
51: cust_object1_id2 okc_k_party_roles_v.object1_id2%type,
52: cust_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
55: lessor_object1_id1 okc_k_party_roles_v.object1_id1%type,
56: lessor_object1_id2 okc_k_party_roles_v.object1_id2%type,
57: lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
58: lessor_name varchar2(250),
59: chr_currency_code okl_k_headers_full_v.currency_code%type,
60: currency_name varchar2(250),
61: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
62: product_name okl_products_v.name%type,
63: product_description okl_products_v.description%type,
57: lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type,
58: lessor_name varchar2(250),
59: chr_currency_code okl_k_headers_full_v.currency_code%type,
60: currency_name varchar2(250),
61: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
62: product_name okl_products_v.name%type,
63: product_description okl_products_v.description%type,
64: khr_khr_id okl_k_headers_full_v.khr_id%type,
65: program_contract_number okl_k_headers_full_v.contract_number%type,
60: currency_name varchar2(250),
61: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
62: product_name okl_products_v.name%type,
63: product_description okl_products_v.description%type,
64: khr_khr_id okl_k_headers_full_v.khr_id%type,
65: program_contract_number okl_k_headers_full_v.contract_number%type,
66: cl_contract_number okl_k_headers_full_v.contract_number%type,
67: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
68: cl_gvr_id okl_k_headers_full_v.id%type,
61: khr_pdt_id okl_k_headers_full_v.pdt_id%type,
62: product_name okl_products_v.name%type,
63: product_description okl_products_v.description%type,
64: khr_khr_id okl_k_headers_full_v.khr_id%type,
65: program_contract_number okl_k_headers_full_v.contract_number%type,
66: cl_contract_number okl_k_headers_full_v.contract_number%type,
67: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
68: cl_gvr_id okl_k_headers_full_v.id%type,
69: rg_larles_id okc_rule_groups_v.id%type,
62: product_name okl_products_v.name%type,
63: product_description okl_products_v.description%type,
64: khr_khr_id okl_k_headers_full_v.khr_id%type,
65: program_contract_number okl_k_headers_full_v.contract_number%type,
66: cl_contract_number okl_k_headers_full_v.contract_number%type,
67: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
68: cl_gvr_id okl_k_headers_full_v.id%type,
69: rg_larles_id okc_rule_groups_v.id%type,
70: r_larles_id okc_rule_groups_v.id%type,
63: product_description okl_products_v.description%type,
64: khr_khr_id okl_k_headers_full_v.khr_id%type,
65: program_contract_number okl_k_headers_full_v.contract_number%type,
66: cl_contract_number okl_k_headers_full_v.contract_number%type,
67: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
68: cl_gvr_id okl_k_headers_full_v.id%type,
69: rg_larles_id okc_rule_groups_v.id%type,
70: r_larles_id okc_rule_groups_v.id%type,
71: r_larles_rule_information1 okc_rules_v.rule_information1%type,
64: khr_khr_id okl_k_headers_full_v.khr_id%type,
65: program_contract_number okl_k_headers_full_v.contract_number%type,
66: cl_contract_number okl_k_headers_full_v.contract_number%type,
67: cl_gvr_chr_id_referred okl_k_headers_full_v.id%type,
68: cl_gvr_id okl_k_headers_full_v.id%type,
69: rg_larles_id okc_rule_groups_v.id%type,
70: r_larles_id okc_rule_groups_v.id%type,
71: r_larles_rule_information1 okc_rules_v.rule_information1%type,
72: col_larles_form_left_prompt varchar2(250),
97: rg_LAPACT_id okc_rule_groups_v.id%type,
98: r_LAPACT_id okc_rule_groups_v.id%type,
99: r_LAPACT_rule_information1 okc_rules_v.rule_information1%type,
100: col_lapact_form_left_prompt varchar2(250),
101: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
102: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
103: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
104: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
105: --Added by dpsingh for LE Uptake
98: r_LAPACT_id okc_rule_groups_v.id%type,
99: r_LAPACT_rule_information1 okc_rules_v.rule_information1%type,
100: col_lapact_form_left_prompt varchar2(250),
101: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
102: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
103: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
104: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
105: --Added by dpsingh for LE Uptake
106: legal_entity_id NUMBER
99: r_LAPACT_rule_information1 okc_rules_v.rule_information1%type,
100: col_lapact_form_left_prompt varchar2(250),
101: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
102: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
103: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
104: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
105: --Added by dpsingh for LE Uptake
106: legal_entity_id NUMBER
107: );
100: col_lapact_form_left_prompt varchar2(250),
101: khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type,
102: khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type,
103: khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type,
104: khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type,
105: --Added by dpsingh for LE Uptake
106: legal_entity_id NUMBER
107: );
108: