DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on AR_GTA_TYPE_MAPPINGS

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 1235: FROM ar_gta_type_mappings jgtm

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