DBA Data[Home] [Help]

APPS.OKE_CHG_REQUESTS_PKG dependencies on OKC_K_HEADERS_B

Line 533: okc_k_headers_b CH

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
537: AND N.Buy_Or_Sell = CH.Buy_Or_Sell;

Line 582: OKC_K_HEADERS_B CH

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
586: AND N.BUY_OR_SELL = CH.BUY_OR_SELL;

Line 600: OKC_K_HEADERS_B CH

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
604: AND N.BUY_OR_SELL = CH.BUY_OR_SELL;