APPS.FUN_TRX_TYPES_PUB dependencies on FUN_TRX_TYPE_AR_MAPS

Line 164: FROM FUN_TRX_TYPE_AR_MAPS tm,

160: m.name,
161: ar.cust_trx_type_id,
162: ar.name ,
163: Nvl(ar.default_term, 4)
164: FROM FUN_TRX_TYPE_AR_MAPS tm,
165: RA_CUST_TRX_TYPES_ALL ar,
166: AR_MEMO_LINES_ALL_VL m
167: WHERE tm.trx_type_id = p_trx_type_id AND
168: tm.org_id = p_org_id AND

Line 182: FROM FUN_TRX_TYPE_AR_MAPS tm,

178: m.name,
179: ar.cust_trx_type_id,
180: ar.name ,
181: null default_term_id
182: FROM FUN_TRX_TYPE_AR_MAPS tm,
183: RA_CUST_TRX_TYPES_ALL ar,
184: AR_MEMO_LINES_ALL_VL m
185: WHERE tm.trx_type_id = p_trx_type_id AND
186: tm.org_id = p_org_id AND

Line 320: FROM FUN_TRX_TYPE_AR_MAPS tm,

316: p_org_id NUMBER,
317: p_trx_date DATE)
318: IS
319: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
320: FROM FUN_TRX_TYPE_AR_MAPS tm,
321: RA_CUST_TRX_TYPES_ALL ar
322: WHERE tm.trx_type_id = p_trx_type_id AND
323: tm.org_id = p_org_id AND
324: tm.org_id = ar.org_id AND

Line 333: FROM FUN_TRX_TYPE_AR_MAPS tm,

329: p_org_id NUMBER,
330: p_trx_date DATE)
331: IS
332: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
333: FROM FUN_TRX_TYPE_AR_MAPS tm,
334: RA_CUST_TRX_TYPES_ALL ar
335: WHERE tm.trx_type_id = p_trx_type_id AND
336: tm.org_id = p_org_id AND
337: tm.org_id = ar.org_id AND