APPS.OKL_OPEN_INTERFACE_PVT dependencies on FND_LOOKUPS

Line 2160: CURSOR fnd_lookup_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE,

2156: FROM okl_party_roles_interface
2157: WHERE contract_number_old = p_contract_number
2158: AND line_number = p_line_number;
2159: */
2160: CURSOR fnd_lookup_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE,
2161: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS
2162: SELECT 'X'
2163: FROM FND_LOOKUPS
2164: WHERE lookup_code = p_lookup_code

Line 2161: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS

2157: WHERE contract_number_old = p_contract_number
2158: AND line_number = p_line_number;
2159: */
2160: CURSOR fnd_lookup_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE,
2161: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS
2162: SELECT 'X'
2163: FROM FND_LOOKUPS
2164: WHERE lookup_code = p_lookup_code
2165: AND lookup_type = p_lookup_type;

Line 2163: FROM FND_LOOKUPS

2159: */
2160: CURSOR fnd_lookup_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE,
2161: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS
2162: SELECT 'X'
2163: FROM FND_LOOKUPS
2164: WHERE lookup_code = p_lookup_code
2165: AND lookup_type = p_lookup_type;
2166:
2167: l_supp_name OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_NAME%TYPE;

Line 6164: FROM fnd_lookups

6160:
6161: l_ok VARCHAR2(1) := '?';
6162: CURSOR usage_type_csr (p_usage_type VARCHAR2) IS
6163: SELECT 'Y'
6164: FROM fnd_lookups
6165: WHERE lookup_type = 'OKS_USAGE_TYPE'
6166: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
6167: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
6168:

Line 19422: FROM FND_LOOKUPS

19418: );
19419:
19420: CURSOR pmnt_basis_csr (p_payment_basis OKL_PARTY_PAYMENT_DTLS.payment_basis%TYPE) IS
19421: SELECT 'Y'
19422: FROM FND_LOOKUPS
19423: WHERE lookup_type = 'OKL_PAYMENT_BASIS'
19424: AND nvl(enabled_flag,'N') = 'Y'
19425: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19426: AND lookup_code = p_payment_basis;

Line 19430: FROM FND_LOOKUPS

19426: AND lookup_code = p_payment_basis;
19427:
19428: CURSOR disb_basis_csr (p_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19429: SELECT 'Y'
19430: FROM FND_LOOKUPS
19431: WHERE lookup_type = 'OKL_DISBURSE_BASIS'
19432: AND nvl(enabled_flag,'N') = 'Y'
19433: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19434: AND lookup_code = p_disbursement_basis;

Line 19438: FROM FND_LOOKUPS

19434: AND lookup_code = p_disbursement_basis;
19435:
19436: CURSOR proc_fee_basis_csr (p_processing_fee_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19437: SELECT 'Y'
19438: FROM FND_LOOKUPS
19439: WHERE lookup_type = 'OKL_PROC_FEE_BASIS'
19440: AND nvl(enabled_flag,'N') = 'Y'
19441: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19442: AND lookup_code = p_processing_fee_basis;

Line 23547: from fnd_lookups lok

23543: validate_real_est_failed EXCEPTION;
23544:
23545: cursor c_prc (p_prc_code VARCHAR2) is
23546: select 1
23547: from fnd_lookups lok
23548: where lok.lookup_type = 'OKL_PROPERTY_CLASS_OPTIONS'
23549: and lok.lookup_code = p_prc_code;
23550:
23551: