APPS.OKE_CHG_REQ_UTILS dependencies on OKE_K_VERS_NUMBERS_H

Line 566: L_Version_Reason_Code OKE_K_VERS_NUMBERS_H.Version_Reason_Code%TYPE;

562: , X_Change_Status OUT NOCOPY VARCHAR2
563: , X_History_Use IN VARCHAR2
564: ) IS
565:
566: L_Version_Reason_Code OKE_K_VERS_NUMBERS_H.Version_Reason_Code%TYPE;
567:
568: CURSOR c IS
569: SELECT CR.Chg_Request_Num
570: , CS.Chg_Status_Name

Line 572: FROM oke_k_vers_numbers_h H

568: CURSOR c IS
569: SELECT CR.Chg_Request_Num
570: , CS.Chg_Status_Name
571: , H.Version_Reason_Code
572: FROM oke_k_vers_numbers_h H
573: , oke_chg_requests CR
574: , oke_chg_statuses_tl CS
575: , ( SELECT K_Header_ID
576: , Chg_Request_ID

Line 578: FROM oke_k_vers_numbers_h

574: , oke_chg_statuses_tl CS
575: , ( SELECT K_Header_ID
576: , Chg_Request_ID
577: , max(Major_Version) Last_Version
578: FROM oke_k_vers_numbers_h
579: GROUP BY K_Header_ID , Chg_Request_ID ) V
580: WHERE V.K_Header_ID = X_K_Header_ID
581: AND H.K_Header_ID = V.K_Header_ID
582: AND H.Major_Version = V.Last_Version