APPS.AR_GTA_ARTRX_PROC dependencies on AR_GTA_TAX_LIMITS_ALL

Line 1134: l_invoice_type_code ar_gta_tax_limits_all.invoice_type%TYPE;

1130: p_transfer_id IN NUMBER,
1131: x_condition_sql OUT NOCOPY VARCHAR2) IS
1132: l_procedure_name VARCHAR2(50) := 'Get_Invoice_Type';
1133: l_error_string VARCHAR2(2000);
1134: l_invoice_type_code ar_gta_tax_limits_all.invoice_type%TYPE;
1135:
1136: l_transaction_type_cnt NUMBER;
1137:
1138: BEGIN

Line 1201: FROM ar_gta_type_mappings jgtm, ar_gta_tax_limits_all jgtla

1197: ELSE
1198: BEGIN
1199: SELECT count(jgtm.transaction_type_id)
1200: INTO l_transaction_type_cnt
1201: FROM ar_gta_type_mappings jgtm, ar_gta_tax_limits_all jgtla
1202: WHERE jgtla.limitation_id = jgtm.limitation_id
1203: AND jgtla.invoice_type = l_invoice_type_code
1204: AND jgtla.org_id = p_org_id;
1205:

Line 1236: ,ar_gta_tax_limits_all jgtla

1232: -- set concatenating sql where clause
1233: x_condition_sql := ' AND h.cust_trx_type_id IN
1234: (SELECT jgtm.transaction_type_id
1235: FROM ar_gta_type_mappings jgtm
1236: ,ar_gta_tax_limits_all jgtla
1237: WHERE jgtm.limitation_id = jgtla.limitation_id
1238: AND jgtla.invoice_type = ''' ||
1239: l_invoice_type_code || '''
1240: AND jgtla.org_id = :p_org_id)';

Line 2084: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;

2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2081: l_period_name GL_PERIODS.Period_Name%TYPE;
2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2083:
2084: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
2085: l_invoice_type_code ar_gta_tax_limits_all.invoice_type%TYPE; --added for bug 13942623
2086:
2087: l_raa_bill_to_concat_address VARCHAR2(500);
2088: l_cust_addr_excep VARCHAR2(20); --added by subba for R12.1

Line 2085: l_invoice_type_code ar_gta_tax_limits_all.invoice_type%TYPE; --added for bug 13942623

2081: l_period_name GL_PERIODS.Period_Name%TYPE;
2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2083:
2084: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
2085: l_invoice_type_code ar_gta_tax_limits_all.invoice_type%TYPE; --added for bug 13942623
2086:
2087: l_raa_bill_to_concat_address VARCHAR2(500);
2088: l_cust_addr_excep VARCHAR2(20); --added by subba for R12.1
2089: l_cust_phone_exp VARCHAR2(20);

Line 3551: FROM ar_gta_tax_limits_all limits

3547: --unit price validate. This will throw a exception AR_GTA_UNITPRICE_ERROR
3548: BEGIN
3549: SELECT limits.max_amount, limits.max_num_of_line
3550: INTO l_max_amount, l_max_num_of_line
3551: FROM ar_gta_tax_limits_all limits
3552: WHERE limits.fp_tax_registration_number =
3553: l_fp_registration_number
3554: AND limits.invoice_type = l_invoice_type
3555: AND limits.org_id = p_org_id;