APPS.OKS_RENEW_UTIL_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 445: FROM okc_k_headers_all_b a, oks_k_headers_b b

441: b.renewal_po_required,
442: b.renewal_est_rev_percent, b.renewal_est_rev_duration, b.renewal_est_rev_period,
443: b.billing_profile_id, b.renewal_grace_duration, b.renewal_grace_period,
444: a.currency_code, a.approval_type, nvl(a.org_id, a.authoring_org_id)
445: FROM okc_k_headers_all_b a, oks_k_headers_b b
446: WHERE a.id = cp_chr_id AND a.id = b.chr_id;
447:
448: --cp_org_id the org for which the rules need to be obtained, can be null
449: --cp_party_id the party for which the rules need to be obtained, can be null

Line 815: --get the contract attributes from okc_k_headers_all_b and oks_k_headers_b

811: END IF;
812:
813: END IF;
814:
815: --get the contract attributes from okc_k_headers_all_b and oks_k_headers_b
816: --also get the contract org id, use this if p_org_id is not passed
817: OPEN c_k_rules(p_chr_id);
818: FETCH c_k_rules INTO lk_rnrl_rec.renewal_type,
819: lk_rnrl_rec.renewal_pricing_type, lk_rnrl_rec.markup_percent, lk_rnrl_rec.price_list_id1,

Line 1037: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b

1033: --should be outer join with party roles, so that
1034: --if we don't get a party we atleast get an org
1035: CURSOR c_k_party_org(cp_chr_id IN NUMBER) IS
1036: SELECT b.object1_id1, a.authoring_org_id
1037: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b
1038: ON a.id = b.dnz_chr_id AND b.cle_id IS NULL AND b.jtot_object1_code = 'OKX_PARTY'
1039: AND b.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
1040: WHERE a.id = cp_chr_id;
1041:

Line 1298: FROM okc_k_headers_all_b

1294: l_error_text VARCHAR2(512);
1295:
1296: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
1297: SELECT estimated_amount, currency_code, start_date
1298: FROM okc_k_headers_all_b
1299: WHERE id = cp_chr_id;
1300:
1301: l_amount NUMBER;
1302: l_currency_code VARCHAR2(15);