[Home] [Help]
100: end_date in date) return number IS
101:
102: CURSOR ar_sales_tax_s_c is
103: select ar_sales_tax_s.nextval + arp_standard.sequence_offset
104: from dual;
105:
106: sales_tax_id NUMBER;
107:
108:
687: r3.end_date ));
688:
689: --
690: CURSOR RateUsed( p_sales_tax_id IN NUMBER ) IS
691: SELECT 'x' from dual
692: WHERE exists (
693: select 'x'
694: from ra_customer_trx_lines l
695: where l.sales_tax_id = p_sales_tax_id );
972: CURSOR sel_rates_c IS
973: SELECT rowid, sales_tax_id from ar_sales_tax;
974:
975: CURSOR PurgeRateUsed( p_sales_tax_id IN NUMBER ) IS
976: SELECT 'x' from dual
977: WHERE exists (
978: select 'x'
979: from ra_customer_trx_lines l
980: where l.sales_tax_id = p_sales_tax_id );
1256: --
1257: -- OPERATION OPTIONS OBJECT_NAME
1258: -- -------------------------------------- --------------- ------------------
1259: -- FILTER
1260: -- TABLE ACCESS FULL DUAL
1261: -- INDEX RANGE SCAN RA_TAX_EXEMPTIONS_N1
1262: --
1263: -- The Where Exists clause ensures that the database stops the search on
1264: -- the index RAX_TAX_EXMEPTIONS_N1 for the first row found.
1264: -- the index RAX_TAX_EXMEPTIONS_N1 for the first row found.
1265: --
1266:
1267: cursor chk_customer_exemption(customer in number) is
1268: select 'x' from dual where exists
1269: ( select 'x' from ra_tax_exemptions where
1270: customer_id = customer );
1271:
1272: --
1368: AND exemption_type = 'ITEM'
1369: AND status = 'PRIMARY'; /* Bugfix 520228 */
1370:
1371: CURSOR sel_tax_exemptions_s is
1372: SELECT ra_tax_exemptions_s.nextval from dual;
1373:
1374: CURSOR sel_location_ids( site_id in number ) is
1375: select c.location_id_segment_1,
1376: c.location_id_segment_2,
1410: l_start_date DATE;
1411: l_end_date DATE;
1412:
1413: l_location_id_segment TAB_ID_TYPE;
1414: dummy dual.dummy%type;
1415: l_display_order NUMBER;
1416:
1417: BEGIN
1418: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');