APPS.OKL_BILLING_REF_WF dependencies on OKC_K_HEADERS_V

Line 63: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

59: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
60: l_msg_data VARCHAR2(2000);
61:
62: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
63: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
64: l_trx_id NUMBER;
65: l_chrv_id NUMBER;
66: l_refund_amnt NUMBER;
67: l_approver VARCHAR2(100);

Line 92: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

88: FROM fnd_lookups frr
89: WHERE frr.lookup_code = p_reason_code
90: AND lookup_type = 'OKL_REFUND_REASON';
91:
92: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
93: IS
94: SELECT chrv.contract_number,chrv.cust_acct_id
95: FROM okc_k_headers_v chrv
96: WHERE chrv.id = p_contract_id;

Line 95: FROM okc_k_headers_v chrv

91:
92: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
93: IS
94: SELECT chrv.contract_number,chrv.cust_acct_id
95: FROM okc_k_headers_v chrv
96: WHERE chrv.id = p_contract_id;
97:
98: --rkuttiya added for bug:3386595
99: CURSOR c_customer(p_cust_acct_id NUMBER) IS