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 330: FROM ar_tax_group_codes_all a,

326: decode (a.compounding_precedence,NULL,0,1) precedence,
327: aa.tax_type tax_type,
328: 'Y' group_flag,
329: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
330: FROM ar_tax_group_codes_all a,
331: ar_vat_tax_all_b aa,
332: zx_tax_priorities_t reg
333: WHERE aa.vat_tax_id = a.tax_code_id
334: AND aa.tax_type = reg.tax_type

Line 339: FROM ar_tax_group_codes_all dup_tax

335: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = reg.org_id
336: 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)
337: AND NOT EXISTS (
338: SELECT 'Y', tax_code_id
339: FROM ar_tax_group_codes_all dup_tax
340: WHERE dup_tax.tax_code_id = a.tax_code_id
341: AND dup_tax.compounding_precedence IS NULL)
342: UNION ALL
343: -- select taxes with no precedence and give and initial of zero

Line 354: FROM ar_tax_group_codes_all a,

350: 0 precedence,
351: aa.tax_type tax_type,
352: 'N' group_flag,
353: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
354: FROM ar_tax_group_codes_all a,
355: ar_vat_tax_all_b aa,
356: zx_tax_priorities_t reg
357: WHERE aa.vat_tax_id = a.tax_code_id
358: AND a.compounding_precedence IS NULL