APPS.OKS_WF_K_PROCESS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 241: FROM okc_k_headers_all_b

237: l_item_key wf_items.item_key%TYPE :=NULL;
238:
239: CURSOR l_kdetails_csr(p_contract_id NUMBER) IS
240: SELECT contract_number,contract_number_modifier
241: FROM okc_k_headers_all_b
242: WHERE id = p_contract_id;
243:
244: l_kdetails_rec l_kdetails_csr%ROWTYPE;
245: l_rownotfound BOOLEAN := FALSE;

Line 428: FROM okc_k_headers_all_b

424: SELECT contract_number,contract_number_modifier,
425: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),
426: fnd_currency.get_format_mask(currency_code, 50)
427: ) estimated_amount, currency_code
428: FROM okc_k_headers_all_b
429: WHERE id = p_chr_id;
430:
431: CURSOR l_install_lang_csr IS
432: SELECT language_code

Line 1197: FROM okc_k_headers_all_b

1193: AND end_date IS NULL;
1194:
1195: CURSOR l_chrid_csr IS
1196: SELECT id
1197: FROM okc_k_headers_all_b
1198: WHERE contract_number = p_contract_number
1199: AND contract_number_modifier = p_contract_number_modifier;
1200:
1201: l_rownotfound BOOLEAN := FALSE;

Line 1409: okc_k_headers_all_b kh

1405: SELECT decode(kh.contract_number_modifier,NULL,kh.contract_number, kh.contract_number||' - '|| kh.contract_number_modifier)
1406: FROM okc_operation_lines ol,
1407: okc_operation_instances oi,
1408: okc_class_operations co,
1409: okc_k_headers_all_b kh
1410: WHERE co.cls_code = 'SERVICE'
1411: AND co.opn_code = 'RENEWAL'
1412: AND co.id = oi.cop_id
1413: AND ol.oie_id = oi.id

Line 1974: FROM okc_k_headers_all_b

1970: SELECT contract_number,contract_number_modifier,
1971: to_char(OKS_EXTWAR_UTIL_PVT.round_currency_amt(estimated_amount,currency_code),
1972: fnd_currency.get_format_mask(currency_code, 50)
1973: ) estimated_amount, currency_code
1974: FROM okc_k_headers_all_b
1975: WHERE id = p_chr_id;
1976:
1977: CURSOR l_install_lang_csr IS
1978: SELECT language_code

Line 2476: FROM okc_k_headers_all_b okch,

2472: l_notif_attr_rec OKS_WF_K_PROCESS_PVT.notif_attr_rec;
2473:
2474: CURSOR l_payment_csr(p_chr_id NUMBER) IS
2475: SELECT fndl.meaning
2476: FROM okc_k_headers_all_b okch,
2477: oks_k_headers_b oksh,
2478: fnd_lookups fndl
2479: WHERE okch.id = oksh.chr_id
2480: AND oksh.chr_id = p_chr_id

Line 2754: FROM OKC_K_HEADERS_ALL_B okck,

2750: l_api_name CONSTANT VARCHAR2(30) := 'customer_decline_quote';
2751:
2752: CURSOR c_old_sts (p_contract_id IN NUMBER) is
2753: SELECT STS_CODE
2754: FROM OKC_K_HEADERS_ALL_B okck,
2755: OKC_STATUSES_B sts
2756: WHERE sts.ste_code = 'ENTERED'
2757: AND id = p_contract_id
2758: AND sts.code = okck.sts_code;

Line 4294: FROM okc_k_headers_all_b

4290: l_api_name CONSTANT VARCHAR2(30) := 'launch_k_process_wf';
4291:
4292: CURSOR l_kdetails_csr(l_contract_id NUMBER) IS
4293: SELECT contract_number, contract_number_modifier
4294: FROM okc_k_headers_all_b
4295: WHERE id = l_contract_id;
4296:
4297: l_contract_number VARCHAR2(120);
4298: l_contract_modifier VARCHAR2(120);

Line 6337: FROM okc_k_headers_all_b

6333:
6334: CURSOR l_qa_csr ( p_chr_id NUMBER ) IS
6335: SELECT contract_number, contract_number_modifier, qcl_id,
6336: authoring_org_id, inv_organization_id
6337: FROM okc_k_headers_all_b
6338: WHERE id = p_chr_id;
6339:
6340: l_contract_id NUMBER;
6341: l_qa_rec l_qa_csr%ROWTYPE;

Line 8553: OKC_K_HEADERS_ALL_B okck,

8549: okck.CONTRACT_NUMBER CONTRACT_NUMBER,
8550: nvl(okck.CONTRACT_NUMBER_MODIFIER, FND_API.G_MISS_CHAR) CONTRACT_NUMBER_MODIFIER,
8551: nvl(oksk.RENEWAL_STATUS, G_NEG_STS_DRAFT) RENEWAL_STATUS
8552: FROM OKS_K_HEADERS_B oksk,
8553: OKC_K_HEADERS_ALL_B okck,
8554: OKC_STATUSES_B sts
8555: WHERE oksk.chr_id = okck.id
8556: AND sts.ste_code = 'ENTERED'
8557: AND sts.code = okck.sts_code