151: ptp.party_tax_profile_id content_owner_id,
152: aa.tax_code parent_tax,
153: bb.tax_code child_tax,
154: decode(l_multi_org_flag,'N',l_org_id,a.org_id) org_id,
155: fnd_global.user_id created_by,
156: sysdate creation_date ,
157: fnd_global.user_id last_updated_by,
158: sysdate last_update_date
159: FROM ar_tax_group_codes_all a,
153: bb.tax_code child_tax,
154: decode(l_multi_org_flag,'N',l_org_id,a.org_id) org_id,
155: fnd_global.user_id created_by,
156: sysdate creation_date ,
157: fnd_global.user_id last_updated_by,
158: sysdate last_update_date
159: FROM ar_tax_group_codes_all a,
160: ar_tax_group_codes_all b,
161: ar_vat_tax_all_b aa,
270: END tax_regime_code ,
271: ROWNUM precedence,
272: decode(l_multi_org_flag,'N',l_org_id,temp_regime.org_id) org_id,
273: temp_regime.tax_type tax_type,
274: fnd_global.user_id created_by,
275: sysdate creation_date ,
276: fnd_global.user_id last_updated_by,
277: sysdate last_update_date
278: FROM
272: decode(l_multi_org_flag,'N',l_org_id,temp_regime.org_id) org_id,
273: temp_regime.tax_type tax_type,
274: fnd_global.user_id created_by,
275: sysdate creation_date ,
276: fnd_global.user_id last_updated_by,
277: sysdate last_update_date
278: FROM
279: (SELECT UNIQUE DECODE(l_multi_org_flag,'N',l_org_id,org_id) org_id , tax_type
280: FROM ar_vat_tax_all_b ) temp_regime;
313: NULL,
314: tax_type,
315: group_flag,
316: org_id,
317: fnd_global.user_id,
318: sysdate ,
319: fnd_global.user_id ,
320: sysdate )
321: -- select taxes (in a group) that have a precedence and give an initial of 1
315: group_flag,
316: org_id,
317: fnd_global.user_id,
318: sysdate ,
319: fnd_global.user_id ,
320: sysdate )
321: -- select taxes (in a group) that have a precedence and give an initial of 1
322: SELECT UNIQUE 'T' tax_regime_flag,
323: reg.tax_regime_code tax_regime_code,