APPS.AR_GTA_TRX_UTIL dependencies on AR_GTA_TAX_LIMITS_ALL

Line 179: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;

175: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
176: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;
177: l_error_string VARCHAR2(1000);
178:
179: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
180: l_class_code hz_code_assignments.CLASS_CODE%TYPE;
181: l_document_subtype zx_lines_det_factors.DOCUMENT_SUB_TYPE%TYPE;
182:
183: BEGIN

Line 191: ar_gta_tax_limits_all jgtla

187: jgtla.invoice_type
188: INTO
189: l_invoice_type
190: FROM
191: ar_gta_tax_limits_all jgtla
192: ,ar_gta_type_mappings jgtm
193: ,ra_customer_trx_all rcta
194: WHERE rcta.customer_trx_id = p_customer_trx_id
195: AND rcta.cust_trx_type_id = jgtm.transaction_type_id

Line 3189: l_invoice_type ar_gta_tax_limits_all.invoice_type%type;

3185: l_amount zx_lines.taxable_amt%TYPE;
3186: l_currency_code VARCHAR2(30);
3187: l_error_string VARCHAR2(500);
3188: --added by subba for R12.1
3189: l_invoice_type ar_gta_tax_limits_all.invoice_type%type;
3190:
3191: tax_error_for_recycle EXCEPTION; --exception for tax_amount check for recycle Invoice
3192:
3193: BEGIN

Line 3322: ar_gta_tax_limits_all

3318: COUNT(*)
3319: INTO
3320: l_fp_reg_number_count
3321: FROM
3322: ar_gta_tax_limits_all
3323: WHERE org_id = p_org_id
3324: AND fp_tax_registration_number = l_tax_registration_number;
3325:
3326: IF l_fp_reg_number_count = 0

Line 4382: UPDATE ar_gta_tax_limits_all

4378: ,g_module_prefix || l_procedure_name || '.begin'
4379: ,'Enter procedure');
4380: END IF; --l_proc_level>=l_dbg_level)
4381: -- initialize invoice type for System Option and Transfer Rules
4382: UPDATE ar_gta_tax_limits_all
4383: SET invoice_type=0
4384: WHERE invoice_type IS NULL
4385: AND org_id = p_org_id;
4386:

Line 4457: FROM ar_gta_tax_limits_all JGTL

4453: WHERE invoice_type is null
4454: AND JGTH.ORG_ID = p_org_id
4455: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4456: AND NOT EXISTS (SELECT JGTL.Limitation_Id
4457: FROM ar_gta_tax_limits_all JGTL
4458: ,ar_gta_type_mappings JGTM
4459: WHERE JGTL.ORG_ID = JGTH.Org_Id
4460: AND JGTL.FP_TAX_REGISTRATION_NUMBER = JGTH.FP_TAX_REGISTRATION_NUMBER
4461: AND JGTM.Limitation_Id = JGTL.LIMITATION_ID

Line 4475: FROM ar_gta_tax_limits_all JGTL

4471: WHERE invoice_type is null
4472: AND JGTH.ORG_ID = p_org_id
4473: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4474: AND EXISTS (SELECT JGTL.Limitation_Id
4475: FROM ar_gta_tax_limits_all JGTL
4476: ,ar_gta_type_mappings JGTM
4477: WHERE JGTL.ORG_ID = JGTH.Org_Id
4478: AND JGTL.FP_TAX_REGISTRATION_NUMBER = JGTH.FP_TAX_REGISTRATION_NUMBER
4479: AND JGTM.Limitation_Id = JGTL.LIMITATION_ID

Line 4552: ,ar_gta_tax_limits_all JGTL

4548: BEGIN
4549: SELECT JGTL.invoice_type
4550: INTO l_invoice_type
4551: FROM RA_CUSTOMER_TRX_ALL RCT
4552: ,ar_gta_tax_limits_all JGTL
4553: WHERE RCT.CUSTOMER_TRX_ID = l_ra_trx_id
4554: AND JGTL.ORG_ID = l_org_id
4555: AND JGTL.FP_TAX_REGISTRATION_NUMBER = l_fp_tax_registration_number
4556: AND RCT.CUST_TRX_TYPE_ID in

Line 4633: ar_gta_tax_limits_all JGTL

4629: -- initialize invoice type for GTA invoices
4630: UPDATE AR_GTA_TRX_HEADERS_ALL JGTH
4631: SET invoice_type = (SELECT JGTL.invoice_type
4632: FROM RA_CUSTOMER_TRX_ALL RCT,
4633: ar_gta_tax_limits_all JGTL
4634: WHERE RCT.CUSTOMER_TRX_ID = JGTH.Ra_Trx_Id
4635: AND JGTL.ORG_ID = JGTH.Org_Id
4636: AND JGTL.FP_TAX_REGISTRATION_NUMBER =
4637: JGTH.FP_TAX_REGISTRATION_NUMBER