APPS.APRX_WT SQL Statements

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

Line: 86

                'aprx_wt.awt_bind(:CURSOR_SELECT);',

Line: 127

	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: 139

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

Line: 144

    		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: 154

       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: 321

          SELECT UPPER(accounting_method_option),
                 UPPER(secondary_accounting_method)
          FROM   ap_system_parameters;