APPS.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_TAX_LIMITS_ALL

Line 1097: l_invoice_type_code jmf_gta_tax_limits_all.invoice_type%TYPE;

1093: p_transfer_id IN NUMBER,
1094: x_condition_sql OUT NOCOPY VARCHAR2) IS
1095: l_procedure_name VARCHAR2(50) := 'Get_Invoice_Type';
1096: l_error_string VARCHAR2(2000);
1097: l_invoice_type_code jmf_gta_tax_limits_all.invoice_type%TYPE;
1098:
1099: l_transaction_type_cnt NUMBER;
1100:
1101: BEGIN

Line 1164: FROM jmf_gta_type_mappings jgtm, jmf_gta_tax_limits_all jgtla

1160: ELSE
1161: BEGIN
1162: SELECT count(jgtm.transaction_type_id)
1163: INTO l_transaction_type_cnt
1164: FROM jmf_gta_type_mappings jgtm, jmf_gta_tax_limits_all jgtla
1165: WHERE jgtla.limitation_id = jgtm.limitation_id
1166: AND jgtla.invoice_type = l_invoice_type_code
1167: AND jgtla.org_id = p_org_id;
1168:

Line 1200: ,jmf_gta_tax_limits_all jgtla

1196: -- set concatenating sql where clause
1197: x_condition_sql := ' AND h.cust_trx_type_id IN
1198: (SELECT jgtm.transaction_type_id
1199: FROM jmf_gta_type_mappings jgtm
1200: ,jmf_gta_tax_limits_all jgtla
1201: WHERE jgtm.limitation_id = jgtla.limitation_id
1202: AND jgtla.invoice_type = ''' ||
1203: l_invoice_type_code || '''
1204: AND jgtla.org_id = :p_org_id)';

Line 2028: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;

2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2025: l_period_name GL_PERIODS.Period_Name%TYPE;
2026: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2027:
2028: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;
2029:
2030: l_raa_bill_to_concat_address VARCHAR2(500);
2031: l_cust_addr_excep VARCHAR2(20); --added by subba for R12.1
2032: l_cust_phone_exp VARCHAR2(20);

Line 3214: FROM jmf_gta_tax_limits_all limits

3210: --unit price validate. This will throw a exception JMF_GTA_UNITPRICE_ERROR
3211: BEGIN
3212: SELECT limits.max_amount, limits.max_num_of_line
3213: INTO l_max_amount, l_max_num_of_line
3214: FROM jmf_gta_tax_limits_all limits
3215: WHERE limits.fp_tax_registration_number =
3216: l_fp_registration_number
3217: AND limits.invoice_type = l_invoice_type
3218: AND limits.org_id = p_org_id;