DBA Data[Home] [Help]

APPS.ZX_TCM_COMPOUND_PKG dependencies on AR_VAT_TAX_ALL_B

Line 161: ar_vat_tax_all_b aa,

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,
165: zx_party_tax_profile ptp,

Line 162: ar_vat_tax_all_b bb,

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,
165: zx_party_tax_profile ptp,
166: ar_vat_tax_all_b grp

Line 166: ar_vat_tax_all_b grp

162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,
164: zx_tax_priorities_t regb,
165: zx_party_tax_profile ptp,
166: ar_vat_tax_all_b grp
167: WHERE decode(l_multi_org_flag,'N',l_org_id,a.org_id) = decode(l_multi_org_flag,'N',l_org_id,b.org_id)
168: AND decode(l_multi_org_flag,'N',l_org_id,a.org_id) = decode(l_multi_org_flag,'N',l_org_id,aa.org_id)
169: AND decode(l_multi_org_flag,'N',l_org_id,b.org_id) = decode(l_multi_org_flag,'N',l_org_id,bb.org_id)
170: AND a.tax_group_id=b.tax_group_id

Line 288: FROM ar_vat_tax_all_b ) temp_regime;

284: fnd_global.user_id last_updated_by,
285: sysdate last_update_date
286: FROM
287: (SELECT UNIQUE DECODE(l_multi_org_flag,'N',l_org_id,org_id) org_id , tax_type
288: FROM ar_vat_tax_all_b ) temp_regime;
289:
290: END load_regime_list;
291:
292:

Line 339: ar_vat_tax_all_b aa,

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
343: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = reg.org_id

Line 363: ar_vat_tax_all_b aa,

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
367: AND aa.tax_type = reg.tax_type