APPS.OKE_CHG_REQ_UTILS dependencies on OKE_CHG_STATUSES_B

Line 42: FROM oke_chg_statuses_b

38:
39: CURSOR sts IS
40: SELECT wf_item_type
41: , wf_process
42: FROM oke_chg_statuses_b
43: WHERE chg_status_code = P_New_Status_Code;
44:
45: CURSOR kh IS
46: SELECT k.k_number_disp

Line 64: FROM oke_chg_statuses_b

60: AND u.employee_id = p.person_id;
61:
62: CURSOR cs ( C_Status_Code VARCHAR2 ) IS
63: SELECT chg_status_type_code
64: FROM oke_chg_statuses_b
65: WHERE chg_status_code = C_Status_Code;
66:
67: l_wf_item_type VARCHAR2(8) := NULL;
68: l_wf_process VARCHAR2(30) := NULL;

Line 427: , oke_chg_statuses_b CS

423: SELECT CRQ2.Chg_Request_Num
424: , CS.Chg_Status_Type_Code
425: FROM oke_chg_requests CRQ1
426: , oke_chg_requests CRQ2
427: , oke_chg_statuses_b CS
428: WHERE CRQ1.Chg_Request_ID = X_Chg_Request_ID
429: AND CRQ2.K_Header_ID = CRQ1.K_Header_ID
430: AND CRQ2.Chg_Request_ID <> CRQ1.Chg_Request_ID
431: AND CS.Chg_Status_Code = CRQ2.Chg_Status_Code

Line 503: , oke_chg_statuses_b CS

499: CURSOR crq IS
500: SELECT COUNT(CRQ2.Chg_Request_Num) ChgReq_Count
501: FROM oke_chg_requests CRQ1
502: , oke_chg_requests CRQ2
503: , oke_chg_statuses_b CS
504: WHERE CRQ1.Chg_Request_ID = X_Chg_Request_ID
505: AND CRQ2.K_Header_ID = CRQ1.K_Header_ID
506: AND CRQ2.Chg_Request_ID <> CRQ1.Chg_Request_ID
507: AND CS.Chg_Status_Code = CRQ2.Chg_Status_Code