APPS.PO_MASS_CLOSE_PO_PVT dependencies on PO_RELEASES

Line 56: l_rel_num po_releases.release_num%TYPE;

52: stmt_rel VARCHAR2(4000);
53: stmt_pa VARCHAR2(4000); --Bug 10371162
54: po_num_type VARCHAR2(100);
55: l_po_num po_headers.clm_document_number%TYPE;
56: l_rel_num po_releases.release_num%TYPE;
57: l_doc_id po_headers.po_header_id%TYPE;
58: l_type_code po_headers.type_lookup_code%TYPE;
59: l_doc_subtype po_document_types.document_subtype%TYPE;
60: l_release_id po_releases.po_release_id%TYPE;

Line 60: l_release_id po_releases.po_release_id%TYPE;

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

Line 503: FROM po_releases por,

499: por.release_num,
500: pdt.document_type_code,
501: pdt.document_subtype,
502: pdt.type_name
503: FROM po_releases por,
504: po_headers poh,
505: po_document_types_vl pdt
506: WHERE por.po_header_id = poh.po_header_id
507: AND pdt.document_type_code = ''RELEASE''