APPS.ZX_TCM_COMPOUND_PKG dependencies on AR_TAX_GROUP_CODES_ALL

Line 63: FROM ar_tax_group_codes_all group_compound

59: -- no branch but compunded
60: -- group with no tax decimal precedence
61: WHEN (same_branch='N' AND
62: NOT EXISTS ( SELECT 'Y'
63: FROM ar_tax_group_codes_all group_compound
64: WHERE group_compound.tax_group_id = rel_tax_group_id
65: AND trunc (group_compound.compounding_precedence) <> group_compound.compounding_precedence
66: )
67: ) THEN

Line 159: FROM ar_tax_group_codes_all a,

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,
162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,

Line 160: ar_tax_group_codes_all b,

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,
162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,
164: zx_tax_priorities_t regb,

Line 338: FROM ar_tax_group_codes_all a,

334: decode (a.compounding_precedence,NULL,0,1) precedence,
335: aa.tax_type tax_type,
336: 'Y' group_flag,
337: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
338: FROM ar_tax_group_codes_all a,
339: ar_vat_tax_all_b aa,
340: zx_tax_priorities_t reg
341: WHERE aa.vat_tax_id = a.tax_code_id
342: AND aa.tax_type = reg.tax_type

Line 347: FROM ar_tax_group_codes_all dup_tax

343: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = reg.org_id
344: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = decode(l_multi_org_flag,'N',l_org_id,a.org_id)
345: AND NOT EXISTS (
346: SELECT 'Y', tax_code_id
347: FROM ar_tax_group_codes_all dup_tax
348: WHERE dup_tax.tax_code_id = a.tax_code_id
349: AND dup_tax.compounding_precedence IS NULL)
350: UNION ALL
351: -- select taxes with no precedence and give and initial of zero

Line 362: FROM ar_tax_group_codes_all a,

358: 0 precedence,
359: aa.tax_type tax_type,
360: 'N' group_flag,
361: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
362: FROM ar_tax_group_codes_all a,
363: ar_vat_tax_all_b aa,
364: zx_tax_priorities_t reg
365: WHERE aa.vat_tax_id = a.tax_code_id
366: AND a.compounding_precedence IS NULL