DBA Data[Home] [Help]

APPS.OKE_K_APPROVAL_WF dependencies on OKC_STATUSES_B

Line 206: , okc_statuses_b ks

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
209: AND ks.code = k.status_code;
210: krec k%rowtype;

Line 398: , okc_statuses_b ks

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;
402: krec k%rowtype;