APPS.PO_RCVTXRTR_NEW_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

    select organization_name
    into l_org
    from org_organization_definitions
    where organization_id = P_org_id ;

Line: 71

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 159

	SELECT 	manual_po_num_type
	, 	manual_req_num_type
	,	manual_receipt_num_type
	INTO	po_numbering_type
	,	req_numbering_type
	,	receipt_numbering_type
	FROM 	po_system_parameters;

Line: 171

	    SELECT 	rcvp.manual_receipt_num_type
	    INTO      	receipt_numbering_type
	    FROM	rcv_parameters rcvp
	    WHERE 	rcvp.organization_id=P_org_id;