DBA Data[Home] [Help]

APPS.OKE_CHG_REQUESTS_PKG dependencies on OKE_K_HEADERS

Line 532: oke_k_headers EH,

528:
529: select Manual_ChgReq_Num_type
530: into Chg_Req_Num_Type
531: from oke_number_options N,
532: oke_k_headers EH,
533: okc_k_headers_b CH
534: WHERE EH.K_Header_ID = X_K_HEADER_ID
535: AND CH.ID = EH.K_Header_ID
536: AND N.K_Type_Code = EH.K_Type_Code

Line 581: OKE_K_HEADERS EH,

577: BEGIN
578: select Manual_ChgReq_Num_Type
579: into Num_Type
580: from OKE_NUMBER_OPTIONS N,
581: OKE_K_HEADERS EH,
582: OKC_K_HEADERS_B CH
583: WHERE EH.K_HEADER_ID = X_K_HEADER_ID
584: AND CH.ID = EH.K_HEADER_ID
585: AND N.K_TYPE_CODE = EH.K_TYPE_CODE

Line 599: OKE_K_HEADERS EH,

595: BEGIN
596: select ChgReq_Num_Mode
597: into Num_Mode
598: from OKE_NUMBER_OPTIONS N,
599: OKE_K_HEADERS EH,
600: OKC_K_HEADERS_B CH
601: WHERE EH.K_HEADER_ID = X_K_HEADER_ID
602: AND CH.ID = EH.K_HEADER_ID
603: AND N.K_TYPE_CODE = EH.K_TYPE_CODE