APPS.PO_SUP_CHG_REQUEST_WF_GRP dependencies on PO_CHANGE_REQUESTS

Line 33: from po_change_requests

29: where po_header_id = p_header_id;
30:
31: select count(1) into
32: l_pending_count
33: from po_change_requests
34: where initiator = 'SUPPLIER'
35: and document_header_id = p_header_id
36: and request_status = 'PENDING'
37: and change_active_flag = 'Y';

Line 47: from po_change_requests

43: where po_release_id = p_release_id;
44:
45: select count(1) into
46: l_pending_count
47: from po_change_requests
48: where initiator = 'SUPPLIER'
49: and document_header_id = p_header_id
50: and po_release_id = p_release_id
51: and request_status = 'PENDING'

Line 489: from po_change_requests

485: /*
486: Note: The Change request handling sometimes can create new rows with request_origin null.
487: */
488: select min(request_origin) into src
489: from po_change_requests
490: where change_request_group_id = l_change_request_group_id and
491: request_origin is not null;
492:
493: exception when no_data_found then