APPS.PO_DOCUMENT_CHECKS_PVT dependencies on FND_LOOKUPS

Line 594: FROM fnd_lookups

590: l_epls_timeframe NUMBER;
591:
592: CURSOR c_eligibility_status_lookup(cp_lookup_code VARCHAR2) IS
593: SELECT meaning
594: FROM fnd_lookups
595: WHERE lookup_type = 'PO_VENDOR_CHECK_STATUS'
596: AND lookup_code = cp_lookup_code
597: AND (SYSDATE BETWEEN start_date_active AND Nvl(end_date_active,SYSDATE+1));
598:

Line 971: FROM fnd_lookups

967: l_enable_eda VARCHAR2(1);
968:
969: CURSOR c_eda_status_lookup(cp_lookup_code VARCHAR2) IS
970: SELECT meaning
971: FROM fnd_lookups
972: WHERE lookup_type = 'PO_EDA_COMPLETION_STATUS'
973: AND lookup_code = cp_lookup_code
974: AND (SYSDATE BETWEEN start_date_active AND Nvl(end_date_active,SYSDATE+1));
975:

Line 26492: FROM fnd_lookups

26488: --x_contract_status := x_contract_rec.contract_status_code;
26489: SELECT meaning
26490: INTO
26491: x_contract_status
26492: FROM fnd_lookups
26493: WHERE lookup_type = 'OKC_REP_CONTRACT_STATUSES'
26494: AND LOOKUP_CODE = x_contract_rec.contract_status_code; -- bug 16713804
26495: IF x_contract_rec.contract_status_code = 'DRAFT' THEN
26496: x_is_draft_status :='Y';