APPS.OKE_BILLING_EVENT_PUB dependencies on OKE_CHG_REQUESTS_V

Line 577: SELECT 'X' FROM oke_chg_requests_v WHERE k_header_id=P_HEADER_ID

573: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
574: L_Value VARCHAR2(1) := 'N';
575:
576: CURSOR C (p_id NUMBER,P_HEADEr_ID NUMBER) IS
577: SELECT 'X' FROM oke_chg_requests_v WHERE k_header_id=P_HEADER_ID
578: AND chg_status_type_code='COMPLETED' AND chg_request_id=p_id ;
579:
580:
581: Begin