APPS.PO_NOTIFICATIONS_SV1 dependencies on PO_RELEASES

Line 30: FROM po_releases

26: x_release_id NUMBER;
27:
28: CURSOR C is
29: SELECT po_release_id
30: FROM po_releases
31: WHERE po_header_id = x_object_id;
32:
33: BEGIN
34:

Line 184: FROM po_releases

180: x_acceptance_due_date DATE;
181:
182: CURSOR C is
183: SELECT po_release_id
184: FROM po_releases
185: WHERE po_header_id = x_object_id
186: AND nvl(cancel_flag,'N') = 'N';
187: BEGIN
188:

Line 467: FROM PO_RELEASES PR,

463: x_acceptance_due_date,
464: x_expiration_date,
465: x_close_date,
466: x_message_name
467: FROM PO_RELEASES PR,
468: PO_HEADERS PH,
469: HR_EMPLOYEES HE
470: WHERE NVL(PR.CANCEL_FLAG,'N') = 'N'
471: AND pr.po_release_id = x_object_id