DBA Data[Home] [Help]

APPS.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_TYPE_MAPPINGS

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 1199: FROM jmf_gta_type_mappings jgtm

1195:
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 || '''