DBA Data[Home] [Help]

APPS.PO_HEADERS_SV1 dependencies on PO_HEADERS_ALL

Line 306: FROM PO_HEADERS_ALL poh /*Bug6632095: using base table instead of view */

302:
303: /* Retrieve PO row_id */
304: SELECT poh.rowid
305: INTO X_rowid
306: FROM PO_HEADERS_ALL poh /*Bug6632095: using base table instead of view */
307: WHERE poh.po_header_id = X_po_header_id;
308:
309: --
310: -- If the calling source is HTML then we need not do the validations as we

Line 334: FROM PO_HEADERS_ALL /*Bug6632095: using base table instead of view */

330: /*po_notifications_sv1.delete_po_notif (x_type_lookup_code,
331: x_po_header_id); */
332: SELECT wf_item_type,wf_item_key
333: INTO x_item_type,x_item_key
334: FROM PO_HEADERS_ALL /*Bug6632095: using base table instead of view */
335: WHERE po_header_id = x_po_header_id;
336:
337: if ((x_item_type is null) and (x_item_key is null)) then
338: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,