DBA Data[Home] [Help]

APPS.OKL_CREDIT_LINE_WF dependencies on OKC_K_HEADERS_ALL_B

Line 636: CURSOR c_get_org_id (p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE)

632: l_message VARCHAR2(12000);
633: l_flag VARCHAR2(10);
634:
635: -- Bug 11896595 by RGOOTY : START
636: CURSOR c_get_org_id (p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE)
637: IS
638: select chr.org_id
639: from okc_k_headers_all_b chr
640: where chr.id = p_contract_id;

Line 639: from okc_k_headers_all_b chr

635: -- Bug 11896595 by RGOOTY : START
636: CURSOR c_get_org_id (p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE)
637: IS
638: select chr.org_id
639: from okc_k_headers_all_b chr
640: where chr.id = p_contract_id;
641:
642: l_org_id NUMBER;
643: l_orig_access_mode VARCHAR2(3);