APPS.PO_MASS_CLOSE_PO_PVT dependencies on PO_RELEASES

Line 55: l_rel_num po_releases.release_num%TYPE;

51: stmt_po VARCHAR2(4000);
52: stmt_rel VARCHAR2(4000);
53: po_num_type VARCHAR2(100);
54: l_po_num po_headers.segment1%TYPE;
55: l_rel_num po_releases.release_num%TYPE;
56: l_doc_id po_headers.po_header_id%TYPE;
57: l_type_code po_headers.type_lookup_code%TYPE;
58: l_doc_subtype po_document_types.document_subtype%TYPE;
59: l_release_id po_releases.po_release_id%TYPE;

Line 59: l_release_id po_releases.po_release_id%TYPE;

55: l_rel_num po_releases.release_num%TYPE;
56: l_doc_id po_headers.po_header_id%TYPE;
57: l_type_code po_headers.type_lookup_code%TYPE;
58: l_doc_subtype po_document_types.document_subtype%TYPE;
59: l_release_id po_releases.po_release_id%TYPE;
60: l_doc_type po_document_types.type_name%TYPE;
61: l_org_id NUMBER;
62: result BOOLEAN;
63: l_return_code VARCHAR2(100);

Line 429: FROM po_releases por,

425: por.release_num,
426: pdt.document_type_code,
427: pdt.document_subtype,
428: pdt.type_name
429: FROM po_releases por,
430: po_headers poh,
431: po_document_types_vl pdt,
432: po_distributions_all pod,
433: po_line_locations_all pll