APPS.PO_PCARD_PKG SQL Statements

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

Line: 13

	        	select 1
                	into x_valid
                	from ap_cards ac
               	 	where ac.card_id = x_pcard_id
                	and (card_expiration_date is null or
               	 	card_expiration_date >= trunc(sysdate))         -- 
                	and (INACTIVE_DATE is null or
                	INACTIVE_DATE >= trunc(sysdate) );              -- 

Line: 81

        INSERT INTO po_session_gt
        ( key
        , index_num1
        )
        VALUES
        ( l_key
        , p_pcard_id_tbl(i)
        );

Line: 95

    SELECT ac.card_id
    BULK COLLECT
    INTO   l_valid_pcard_id_tbl
    FROM   ap_cards_all    ac
    ,      po_session_gt   gt
    WHERE  ac.card_id = gt.index_num1        -- select only P-cards in GT table
    AND    gt.key = l_key                    -- which we inserted above
    AND    (   ( ac.card_expiration_date IS NULL )
           OR  ( ac.card_expiration_date >= trunc(sysdate) ) )
    AND    (   ( ac.inactive_date IS NULL )
           OR  ( ac.inactive_date >= trunc(sysdate) ) );

Line: 119

    DELETE FROM po_session_gt gt
	WHERE       gt.key = l_key;

Line: 178

               	 select 1
               	 into x_valid
               	  from po_vendor_sites_all pvs
                	where pvs.VENDOR_ID = x_vendor_id
               	 	and pvs.vendor_site_id = x_vendor_site_id
               	 	and pvs.pcard_site_flag = 'Y';

Line: 261

		select  card_id into x_pcard_id
		from ap_card_suppliers
		where vendor_id = x_vendor_id
		and vendor_site_id = x_vendor_site_id;