APPS.ZX_P2P_DEF_AP_PREUPG dependencies on AP_TAX_CODES_ALL

Line 265: TYPE tax_id_table is table of ap_tax_codes_all.tax_id%TYPE index by BINARY_INTEGER;

261: |==========================================================================*/
262:
263: PROCEDURE migrate_disabled_tax_codes(p_tax_id IN NUMBER DEFAULT NULL) IS
264:
265: TYPE tax_id_table is table of ap_tax_codes_all.tax_id%TYPE index by BINARY_INTEGER;
266: tax_id_tab tax_id_table ;
267: l_min_start_date date;
268: l_max_end_date date;
269:

Line 295: from ap_tax_codes_all a

291: select aptax2.tax_id tax_id
292: from
293: (
294: select DISTINCT org_id,set_of_books_id,name
295: from ap_tax_codes_all a
296: where a.enabled_flag = 'N'
297: and exists
298: (
299: select 1 from ap_tax_codes_all b

Line 299: select 1 from ap_tax_codes_all b

295: from ap_tax_codes_all a
296: where a.enabled_flag = 'N'
297: and exists
298: (
299: select 1 from ap_tax_codes_all b
300: where a.org_id = b.org_id
301: and a.set_of_books_id = b.set_of_books_id
302: and a.name = b.name
303: and

Line 318: (select c.org_id,c.set_of_books_id,c.name ,count(c.org_id) from ap_tax_codes_all c

314: )
315: and b.enabled_flag = 'N'
316: )
317: and exists
318: (select c.org_id,c.set_of_books_id,c.name ,count(c.org_id) from ap_tax_codes_all c
319: where a.org_id = c.org_id
320: and a.set_of_books_id = c.set_of_books_id
321: and a.name = c.name
322: group by c.org_id,c.set_of_books_id,c.name

Line 326: ap_tax_codes_all aptax2

322: group by c.org_id,c.set_of_books_id,c.name
323: having count(c.org_id) > 1)
324: )
325: aptax1,
326: ap_tax_codes_all aptax2
327: where
328: aptax1.org_id = aptax2.org_id
329: and aptax1.set_of_books_id = aptax2.set_of_books_id
330: and aptax1. name = aptax2. name

Line 425: from ap_tax_codes_all,

421: BEGIN
422:
423: SELECT 'Y' INTO ID_CLASH FROM DUAL
424: WHERE EXISTS (select 1
425: from ap_tax_codes_all,
426: ar_vat_tax_all_b
427: where tax_id = vat_tax_id);
428: EXCEPTION
429: WHEN no_data_found THEN