APPS.PO_CREATE_SR_ASL dependencies on PO_DOCUMENT_TYPES_ALL

Line 569: l_archive_on_approve PO_DOCUMENT_TYPES_ALL.archive_external_revision_code%type;

565: p_release_gen_method IN PO_ASL_ATTRIBUTES.release_generation_method%type,
566: p_assignment_set_id IN MRP_ASSIGNMENT_SETS.assignment_set_id%type) IS
567:
568: /* Local variables declared for Concurrent Program specific requirements */
569: l_archive_on_approve PO_DOCUMENT_TYPES_ALL.archive_external_revision_code%type;
570: l_previous_line_num PO_LINES_ALL.line_num%type;
571: l_orgid PO_HEADERS_ALL.org_id%type;
572:
573: /* Local variables Package specific information... Required for logging */

Line 720: FROM po_document_types_all

716: -- SQL Why: Would continue processing only if archival is on 'APPROVE'
717:
718: SELECT archive_external_revision_code
719: INTO l_archive_on_approve
720: FROM po_document_types_all
721: WHERE org_id=l_orgid
722: AND document_type_code='PA'
723: AND document_subtype='BLANKET';
724: