APPS.ARH_ADDR_PKG dependencies on DUAL

Line 938: select hr_locations_s.nextval into x_location_id from dual;

934: IF x_location_id is null THEN
935: l_count := 1;
936:
937: WHILE l_count > 0 loop
938: select hr_locations_s.nextval into x_location_id from dual;
939:
940: select count(*) into l_count
941: from hz_locations
942: where location_id = x_location_id;

Line 965: select hr_locations_s.nextval into x_location_id from dual;

961:
962: l_count := 1;
963:
964: WHILE l_count > 0 loop
965: select hr_locations_s.nextval into x_location_id from dual;
966:
967: select count(*) into l_count
968: from hz_locations
969: where location_id = x_location_id;

Line 2077: from dual

2073: loop
2074: --
2075: select 'x'
2076: into invoice_count
2077: from dual
2078: where exists ( select 'y'
2079: from ra_cust_trx_types ctt,
2080: ra_customer_trx_lines ctl,
2081: ra_customer_trx ct

Line 2117: from dual

2113: for j in bill_to_site
2114: loop
2115: select 'x'
2116: into invoice_count
2117: from dual
2118: where exists ( select 'y'
2119: from ra_cust_trx_types ctt,
2120: ra_customer_trx_lines ctl,
2121: ra_customer_trx ct

Line 2236: from dual

2232: BEGIN
2233: arp_debug.debug(' cursor SHIP_TO_SITE site_use_id retrieved:'||i.site_use_id);
2234: select 'x'
2235: into invoice_count
2236: from dual
2237: where exists ( select 'y'
2238: from ra_cust_trx_types_all ctt,
2239: ra_customer_trx_lines_all ctl,
2240: ra_customer_trx_all ct

Line 2285: from dual

2281: loop
2282: arp_debug.debug(' cursor BILL_TO_SITE site_use_id retrieved:'||j.site_use_id);
2283: select 'x'
2284: into invoice_count
2285: from dual
2286: where exists ( select 'y'
2287: from ra_cust_trx_types_all ctt,
2288: ra_customer_trx_lines_all ctl,
2289: ra_customer_trx_all ct