APPS.FUN_TRX_TYPES_PUB dependencies on FUN_SYSTEM_OPTIONS

Line 173: FROM fun_system_options fun,

169: m.name,
170: ar.cust_trx_type_id,
171: ar.name,
172: 4 default_term_id
173: FROM fun_system_options fun,
174: RA_CUST_TRX_TYPES_ALL ar,
175: AR_MEMO_LINES_ALL_VL m
176: WHERE fun.default_memo_line_id = m.memo_line_id
177: AND fun.default_ar_trx_type_id = ar.cust_trx_type_id

Line 248: FROM fun_system_options fun,

244: CURSOR c_get_def ( p_org_id NUMBER,
245: p_trx_date DATE)
246: IS
247: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
248: FROM fun_system_options fun,
249: RA_CUST_TRX_TYPES_ALL ar
250: WHERE fun.default_ar_trx_type_id = ar.cust_trx_type_id
251: AND ar.org_id = p_org_id
252: AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);