APPS.PO_POXRCPPV_XMLP_PKG SQL Statements

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

Line: 13

    select organization_name
    into l_org
    from org_organization_definitions
    where organization_id = P_org_id ;

Line: 27

    SELECT trunc(P_Trans_Date_to) +1 - .00001
    INTO P_Trans_Date_to
    FROM DUAL;

Line: 52

       'AND wt.transaction_type = 3 AND exists (select 1 from wip_transaction_accounts wta '||
       'where wta.transaction_id = wt.transaction_id and wta.accounting_line_type = 6)' );

Line: 161

	select status
	into   P_wip_status
	from   fnd_product_installations
	where  application_id = 706;

Line: 166

	P_select_wip := get_std_unit_cost;

Line: 172

		P_select_wip := null;