DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on PO_UDA_AG_TEMPLATES

Line 317: FROM po_uda_ag_templates

313: SELECT database_view_name,
314: template_id
315: INTO x_database_view_name,
316: x_template_id
317: FROM po_uda_ag_templates
318: WHERE template_id = (SELECT prh.uda_template_id
319: FROM po_requisition_headers_all prh
320: WHERE prh.conformed_header_id= p_confirmed_id
321: AND prh.revision_num=p_revision_num);

Line 347: FROM po_uda_ag_templates

343: ELSIF p_table_name = 'PO_REQ_LINES_UDA' THEN
344:
345: SELECT database_view_name
346: INTO x_database_view_name
347: FROM po_uda_ag_templates
348: WHERE template_id = (SELECT Max(prl.uda_template_id)
349: FROM po_requisition_lines_all prl,
350: po_requisition_headers_all prh
351: WHERE prh.conformed_header_id= p_confirmed_id