DBA Data[Home] [Help]

APPS.OKL_PAYMENT_PVT dependencies on OKC_K_HEADERS_B

Line 45: FROM okc_k_headers_b

41: RETURN VARCHAR2 AS
42: -- get org_id for contract
43: CURSOR get_org_id_csr (p_contract_id IN VARCHAR2) IS
44: SELECT authoring_org_id
45: FROM okc_k_headers_b
46: WHERE id = p_contract_id;
47:
48: l_api_version NUMBER;
49: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 545: l_contract_id OKC_K_HEADERS_B.ID%TYPE;

541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
543: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
544: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
545: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
546: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
547: l_cust_acct_id NUMBER;
548: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
549: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 546: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
543: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
544: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
545: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
546: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
547: l_cust_acct_id NUMBER;
548: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
549: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
550: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;