APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSP_PICK_UTILS

Line 1219: CSP_PICK_UTILS.get_order_status (ol.LINE_ID, ol.FLOW_STATUS_CODE) order_status,

1215: CURSOR c_req_lines(b_acc_id NUMBER)
1216: IS
1217: SELECT acc.USER_ID,usr.USER_NAME,usr.email_address,
1218: acc.requirement_line_id,oh.order_number,
1219: CSP_PICK_UTILS.get_order_status (ol.LINE_ID, ol.FLOW_STATUS_CODE) order_status,
1220: nvl(ol.actual_arrival_date,ol.schedule_arrival_date) arrival_date
1221: FROM csm_req_lines_acc acc
1222: , CSP_REQ_LINE_DETAILS crld
1223: , OE_ORDER_LINES_ALL ol, OE_ORDER_HEADERS_ALL oh