APPS.ARH_ARXCUDCI_PKG SQL Statements

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

Line: 53

	  select gr.name
	  into    grouping_rule
	  from    ra_grouping_rules gr
	  where   gr.grouping_rule_id = arp_standard.sysparm.default_grouping_rule_id
	  and     trunc(sysdate) BETWEEN gr.start_date AND nvl(gr.end_date, trunc(sysdate));

Line: 66

	SELECT 	currency_code
	INTO	functional_currency
	FROM	gl_sets_of_books
	WHERE	set_of_books_id = arp_standard.sysparm.set_of_books_id;

Line: 92

	  select territory_short_name,address_style
	  into 	 default_country_disp,address_style
	  from 	 fnd_territories_vl
	  where  territory_code = default_country_code;

Line: 109

	  select 	cpc.name
  	  into 	profile_class
  	  from 	hz_cust_profile_classes cpc
 	  WHERE cpc.status 		      = 'A'
   	  AND 	cpc.profile_class_id = 0;