DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on FND_LOOKUPS

Line 62: FROM fnd_lookups

58:
59:
60: Cursor funding_disb_txn_type_csr(p_code VARCHAR2) IS
61: SELECT meaning
62: FROM fnd_lookups
63: WHERE lookup_type = 'OKL_FUNDING_TYPE'
64: AND lookup_code = p_code;
65:
66: Cursor Billing_invoice_status_csr(p_contract_id NUMBER) IS

Line 85: l_txn_type FND_LOOKUPS.meaning%TYPE;

81: l_api_version CONSTANT NUMBER := 1.0;
82: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
83: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;
84: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;
85: l_txn_type FND_LOOKUPS.meaning%TYPE;
86: l_bankruptcy_status VARCHAR2(1);
87: l_status_code OKC_K_HEADERS_B.sts_code%TYPE;
88: l_billing_invoice_status VARCHAR2(1) := '?';
89: l_advance_receipt_status VARCHAR2(1) := '?';