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 5192: -- okc_statuses_b st,

5188: -- kh.id contract_id,
5189: -- Nvl(rul.rule_information1,0) percent,
5190: -- st.ste_code
5191: -- FROM okc_k_headers_b kh,
5192: -- okc_statuses_b st,
5193: -- okc_rules_b rul
5194: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5195: -- AND kh.sts_code = st.code
5196: -- AND st.ste_code = 'ENTERED'

Line 5218: -- okc_statuses_b st,

5214: -- kh.id contract_id,
5215: -- Nvl(rul.est_rev_percent,0) percent,
5216: -- st.ste_code
5217: -- FROM okc_k_headers_b kh,
5218: -- okc_statuses_b st,
5219: -- oks_k_headers_b rul
5220: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5221: -- AND kh.scs_code in ('SERVICE','WARRANTY')
5222: -- AND kh.sts_code = st.code

Line 5246: okc_statuses_b st,

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

Line 5269: okc_statuses_b st,

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

Line 5291: okc_statuses_b st,

5287: IS
5288: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5289: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5290: FROM okc_k_headers_b kh,
5291: okc_statuses_b st,
5292: oks_k_headers_b rul,
5293: (SELECT included_chr_id
5294: FROM okc_k_grpings
5295: START WITH cgp_parent_id = p_contract_group

Line 5313: okc_statuses_b st,

5309: IS
5310: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5311: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5312: FROM okc_k_headers_b kh,
5313: okc_statuses_b st,
5314: oks_k_headers_b rul,
5315: (SELECT included_chr_id
5316: FROM okc_k_grpings
5317: START WITH cgp_parent_id = p_contract_group

Line 5407: ste_code okc_statuses_b.ste_code%TYPE

5403: currency_code okc_k_headers_b.currency_code%TYPE,
5404: sts_code okc_k_headers_b.sts_code%TYPE,
5405: contract_id okc_k_headers_b.ID%TYPE,
5406: PERCENT VARCHAR2 (50),
5407: ste_code okc_statuses_b.ste_code%TYPE
5408: );
5409:
5410: l_kh_rec kh_rectype;
5411: l_curncy_status_prev VARCHAR2 (200) := '~#~';