DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKC_K_HEADERS_B

Line 1440: FROM OKC_K_HEADERS_B

1436: asset_change_failed EXCEPTION;
1437: --Added by dpsingh for LE uptake
1438: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
1439: SELECT contract_number
1440: FROM OKC_K_HEADERS_B
1441: WHERE id = p_ctr_id1;
1442:
1443: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1444: l_legal_entity_id NUMBER;

Line 1443: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1439: SELECT contract_number
1440: FROM OKC_K_HEADERS_B
1441: WHERE id = p_ctr_id1;
1442:
1443: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1444: l_legal_entity_id NUMBER;
1445:
1446: BEGIN
1447: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 2404: okc_k_headers_b hdr

2400:
2401: CURSOR con_sts_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2402: SELECT sts.ste_code
2403: FROM okc_statuses_b sts,
2404: okc_k_headers_b hdr
2405: WHERE hdr.sts_code = sts.code
2406: AND hdr.id = p_chr_id;
2407:
2408: l_request_name okl_rbk_selected_contract.request_name%TYPE;