APPS.OKE_CHG_REQUESTS_PKG dependencies on OKE_NUMBER_OPTIONS

Line 531: from oke_number_options N,

527: Chg_Req_Num_OK := 'T';
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

Line 580: from OKE_NUMBER_OPTIONS N,

576: Num_Type varchar2(30);
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

Line 598: from OKE_NUMBER_OPTIONS N,

594: Num_Mode varchar2(30);
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