APPS.OKL_OPEN_INTERFACE_PVT dependencies on FND_LOOKUPS

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

2062: FROM okl_party_roles_interface
2063: WHERE contract_number_old = p_contract_number
2064: AND line_number = p_line_number;
2065: */
2066: CURSOR fnd_lookup_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE,
2067: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS
2068: SELECT 'X'
2069: FROM FND_LOOKUPS
2070: WHERE lookup_code = p_lookup_code

Line 2067: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS

2063: WHERE contract_number_old = p_contract_number
2064: AND line_number = p_line_number;
2065: */
2066: CURSOR fnd_lookup_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE,
2067: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS
2068: SELECT 'X'
2069: FROM FND_LOOKUPS
2070: WHERE lookup_code = p_lookup_code
2071: AND lookup_type = p_lookup_type;

Line 2069: FROM FND_LOOKUPS

2065: */
2066: CURSOR fnd_lookup_csr(p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE,
2067: p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE) IS
2068: SELECT 'X'
2069: FROM FND_LOOKUPS
2070: WHERE lookup_code = p_lookup_code
2071: AND lookup_type = p_lookup_type;
2072:
2073: l_supp_name OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_NAME%TYPE;

Line 5996: FROM fnd_lookups

5992:
5993: l_ok VARCHAR2(1) := '?';
5994: CURSOR usage_type_csr (p_usage_type VARCHAR2) IS
5995: SELECT 'Y'
5996: FROM fnd_lookups
5997: WHERE lookup_type = 'OKS_USAGE_TYPE'
5998: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date_active), TRUNC(SYSDATE)) AND
5999: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
6000:

Line 19240: FROM FND_LOOKUPS

19236: );
19237:
19238: CURSOR pmnt_basis_csr (p_payment_basis OKL_PARTY_PAYMENT_DTLS.payment_basis%TYPE) IS
19239: SELECT 'Y'
19240: FROM FND_LOOKUPS
19241: WHERE lookup_type = 'OKL_PAYMENT_BASIS'
19242: AND nvl(enabled_flag,'N') = 'Y'
19243: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19244: AND lookup_code = p_payment_basis;

Line 19248: FROM FND_LOOKUPS

19244: AND lookup_code = p_payment_basis;
19245:
19246: CURSOR disb_basis_csr (p_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19247: SELECT 'Y'
19248: FROM FND_LOOKUPS
19249: WHERE lookup_type = 'OKL_DISBURSE_BASIS'
19250: AND nvl(enabled_flag,'N') = 'Y'
19251: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19252: AND lookup_code = p_disbursement_basis;

Line 19256: FROM FND_LOOKUPS

19252: AND lookup_code = p_disbursement_basis;
19253:
19254: CURSOR proc_fee_basis_csr (p_processing_fee_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19255: SELECT 'Y'
19256: FROM FND_LOOKUPS
19257: WHERE lookup_type = 'OKL_PROC_FEE_BASIS'
19258: AND nvl(enabled_flag,'N') = 'Y'
19259: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19260: AND lookup_code = p_processing_fee_basis;

Line 23358: from fnd_lookups lok

23354: validate_real_est_failed EXCEPTION;
23355:
23356: cursor c_prc (p_prc_code VARCHAR2) is
23357: select 1
23358: from fnd_lookups lok
23359: where lok.lookup_type = 'OKL_PROPERTY_CLASS_OPTIONS'
23360: and lok.lookup_code = p_prc_code;
23361:
23362: