DBA Data[Home] [Help]

APPS.OKE_K_APPROVAL_WF dependencies on OKE_K_HEADERS

Line 204: FROM oke_k_headers_v k

200: , k.description
201: , k.authoring_org_id
202: , k.status_code
203: , ks.ste_code
204: FROM oke_k_headers_v k
205: , oke_k_types_vl kt
206: , okc_statuses_b ks
207: WHERE k.k_header_id = C_K_Header_ID
208: AND kt.k_type_code = k.k_type_code

Line 397: , oke_k_headers k

393:
394: CURSOR k ( C_K_Header_ID NUMBER ) IS
395: SELECT ks.ste_code
396: FROM okc_k_headers_b boa
397: , oke_k_headers k
398: , okc_statuses_b ks
399: WHERE k.k_header_id = C_K_Header_ID
400: AND boa.id = k.boa_id
401: AND ks.code = boa.sts_code;