APPS.QA_FLEX_UTIL dependencies on OKE_K_HEADERS_LOV_V

Line 476: -- Return contract_number from oke_k_headers_lov_v

472: -- avoid outjoin to complex views as will cause full table scan.
473: -- jezheng
474: -- Wed Sep 13 11:00:28 PDT 2000
475:
476: -- Return contract_number from oke_k_headers_lov_v
477: -- given a contract ID.
478:
479: FUNCTION contract_number(x_id number) RETURN varchar2 IS
480:

Line 484: FROM oke_k_headers_lov_v

480:
481: x_contract_number varchar2(120) := NULL;
482: CURSOR c IS
483: SELECT k_number
484: FROM oke_k_headers_lov_v
485: WHERE k_header_id = x_id;
486:
487: BEGIN
488: IF x_id IS NOT NULL THEN