DBA Data[Home] [Help]

APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on FND_LOOKUPS

Line 470: FROM fnd_lookups

466: FUNCTION get_lookup_value (p_lookup_code VARCHAR2) RETURN VARCHAR2 IS
467:
468: CURSOR c_get_lookup_value IS
469: SELECT meaning
470: FROM fnd_lookups
471: WHERE lookup_type = 'PO_VENDOR_CHECK_STATUS'
472: AND (SYSDATE BETWEEN start_date_active AND Nvl(end_date_active,SYSDATE+1))
473: AND lookup_code = p_lookup_code ;
474:

Line 854: FROM fnd_lookups

850: l_epls_timeframe NUMBER;
851:
852: CURSOR c_eligibility_status_lookup(cp_lookup_code VARCHAR2) IS
853: SELECT meaning
854: FROM fnd_lookups
855: WHERE lookup_type = 'PO_VENDOR_CHECK_STATUS'
856: AND lookup_code = cp_lookup_code
857: AND (SYSDATE BETWEEN start_date_active AND Nvl(end_date_active,SYSDATE+1));
858: