APPS.JMF_GTA_TRX_UTIL dependencies on JMF_GTA_TAX_LIMITS_ALL

Line 150: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;

146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
147: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;
148: l_error_string VARCHAR2(1000);
149:
150: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;
151:
152: BEGIN
153:
154:

Line 160: jmf_gta_tax_limits_all jgtla

156: jgtla.invoice_type
157: INTO
158: l_invoice_type
159: FROM
160: jmf_gta_tax_limits_all jgtla
161: ,jmf_gta_type_mappings jgtm
162: ,ra_customer_trx_all rcta
163: WHERE rcta.customer_trx_id = p_customer_trx_id
164: AND rcta.cust_trx_type_id = jgtm.transaction_type_id

Line 2471: l_invoice_type jmf_gta_tax_limits_all.invoice_type%type;

2467: l_amount zx_lines.taxable_amt%TYPE;
2468: l_currency_code VARCHAR2(30);
2469: l_error_string VARCHAR2(500);
2470: --added by subba for R12.1
2471: l_invoice_type jmf_gta_tax_limits_all.invoice_type%type;
2472:
2473: tax_error_for_recycle EXCEPTION; --exception for tax_amount check for recycle Invoice
2474:
2475: BEGIN

Line 2602: jmf_gta_tax_limits_all

2598: COUNT(*)
2599: INTO
2600: l_fp_reg_number_count
2601: FROM
2602: jmf_gta_tax_limits_all
2603: WHERE org_id = p_org_id
2604: AND fp_tax_registration_number = l_tax_registration_number;
2605:
2606: IF l_fp_reg_number_count = 0