APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_STATUSES_B

Line 412: ,OKC_STATUSES_B CST

408:
409: CURSOR c_Chr(c_CHR_ID IN NUMBER) IS
410: SELECT Id
411: FROM OKC_K_HEADERS_B CHR
412: ,OKC_STATUSES_B CST
413: WHERE CHR.STS_CODE = CST.CODE
414: AND CHR.DATE_TERMINATED IS NULL
415: AND CST.STE_CODE IN ( 'ACTIVE', 'SIGNED')
416: AND CHR.ID = c_CHR_ID;

Line 5146: -- okc_statuses_b st,

5142: -- kh.id contract_id,
5143: -- Nvl(rul.rule_information1,0) percent,
5144: -- st.ste_code
5145: -- FROM okc_k_headers_b kh,
5146: -- okc_statuses_b st,
5147: -- okc_rules_b rul
5148: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5149: -- AND kh.sts_code = st.code
5150: -- AND st.ste_code = 'ENTERED'

Line 5172: -- okc_statuses_b st,

5168: -- kh.id contract_id,
5169: -- Nvl(rul.est_rev_percent,0) percent,
5170: -- st.ste_code
5171: -- FROM okc_k_headers_b kh,
5172: -- okc_statuses_b st,
5173: -- oks_k_headers_b rul
5174: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5175: -- AND kh.scs_code in ('SERVICE','WARRANTY')
5176: -- AND kh.sts_code = st.code

Line 5200: okc_statuses_b st,

5196: IS
5197: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5198: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5199: FROM okc_k_headers_b kh,
5200: okc_statuses_b st,
5201: oks_k_headers_b rul,
5202: (SELECT included_chr_id
5203: FROM okc_k_grpings
5204: START WITH cgp_parent_id = p_contract_group

Line 5223: okc_statuses_b st,

5219: IS
5220: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5221: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5222: FROM okc_k_headers_b kh,
5223: okc_statuses_b st,
5224: oks_k_headers_b rul,
5225: (SELECT included_chr_id
5226: FROM okc_k_grpings
5227: START WITH cgp_parent_id = p_contract_group

Line 5245: okc_statuses_b st,

5241: IS
5242: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5243: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5244: FROM okc_k_headers_b kh,
5245: okc_statuses_b st,
5246: oks_k_headers_b rul,
5247: (SELECT included_chr_id
5248: FROM okc_k_grpings
5249: START WITH cgp_parent_id = p_contract_group

Line 5267: okc_statuses_b st,

5263: IS
5264: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5265: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5266: FROM okc_k_headers_b kh,
5267: okc_statuses_b st,
5268: oks_k_headers_b rul,
5269: (SELECT included_chr_id
5270: FROM okc_k_grpings
5271: START WITH cgp_parent_id = p_contract_group

Line 5361: ste_code okc_statuses_b.ste_code%TYPE

5357: currency_code okc_k_headers_b.currency_code%TYPE,
5358: sts_code okc_k_headers_b.sts_code%TYPE,
5359: contract_id okc_k_headers_b.ID%TYPE,
5360: PERCENT VARCHAR2 (50),
5361: ste_code okc_statuses_b.ste_code%TYPE
5362: );
5363:
5364: l_kh_rec kh_rectype;
5365: l_curncy_status_prev VARCHAR2 (200) := '~#~';