APPS.APRX_WT SQL Statements

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

Line: 120

                'aprx_wt.awt_bind(:CURSOR_SELECT);',

Line: 167

	select	CURRENCY_CODE,NAME
   	into 	var.functional_currency_code
	,	var.organization_name
   	from 	GL_SETS_OF_BOOKS
   	where 	SET_OF_BOOKS_ID = var.books_id;

Line: 179

/*    		SELECT name
    		INTO var.organization_name
    		FROM hr_organization_units
    		WHERE organization_id = FND_PROFILE.GET('ORG_ID');

Line: 184

    		SELECT currency_code
    		INTO var.functional_currency_code
    		FROM gl_sets_of_books
    		WHERE set_of_books_id = FND_PROFILE.GET('GL_SET_OF_BKS_ID');

Line: 195

       SELECT hrl.address_line_1,
              hrl.address_line_2,
	      hrl.address_line_3,
              hrl.town_or_city,
	      hrl.country,
              hrl.postal_code,
              hrl.region_1,
              hrl.region_2
        INTO var.Address_line1,
	     var.address_line2,
	     var.address_line3,
             var.city,
             var.country,
             var.zip,
             var.province,
             var.state
        FROM hr_locations hrl
        WHERE hrl.location_id = JG_ZZ_COMPANY_INFO.get_location_id;

Line: 416

          SELECT UPPER(gld.SLA_LEDGER_CASH_BASIS_FLAG),
                 UPPER(secondary_accounting_method)
          FROM   ap_system_parameters asp,
		         gl_ledgers gld
		  WHERE asp.set_of_books_id = gld.ledger_id;