APPS.OKS_RENEW_UTIL_PVT dependencies on OKS_K_HEADERS_B

Line 321: FROM oks_k_headers_b

317:
318: CURSOR get_hdr_period_val(p_hdr_id IN NUMBER)
319: IS
320: SELECT period_type, period_start, price_uom
321: FROM oks_k_headers_b
322: WHERE chr_id = p_hdr_id;
323:
324: CURSOR get_gcd_org_period_val (p_org_id IN VARCHAR2)
325: IS

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,