APPS.OKC_REP_UTIL_PVT dependencies on FND_LOOKUPS

Line 3706: SELECT LOOKUP_CODE FROM FND_LOOKUPS

3702:
3703: l_import_contracts_rec IMPORT_CONTRACTS_CSR%ROWTYPE;
3704:
3705: CURSOR CONTRACT_STATUS_CSR (p_status_txt VARCHAR2) IS
3706: SELECT LOOKUP_CODE FROM FND_LOOKUPS
3707: WHERE LOOKUP_TYPE = 'OKC_REP_CONTRACT_STATUSES'
3708: AND LOOKUP_CODE = 'SIGNED'
3709: AND UPPER(MEANING) = UPPER(p_status_txt);
3710:

Line 3746: FROM FND_LOOKUPS

3742: AND ENABLED_FLAG = 'Y';
3743:
3744: CURSOR AUTHORING_PARTY_CSR (p_authoring_party_txt VARCHAR2) IS
3745: SELECT LOOKUP_CODE
3746: FROM FND_LOOKUPS
3747: WHERE LOOKUP_TYPE = 'OKC_AUTHORING_PARTY'
3748: AND UPPER(MEANING) = UPPER(p_authoring_party_txt);
3749:
3750: CURSOR CONTRACT_PARTIES_CSR (p_contract_id VARCHAR2) IS