APPS.FUN_TRX_TYPES_PUB dependencies on FUN_SYSTEM_OPTIONS

Line 201: FROM fun_system_options fun,

197: m.name,
198: ar.cust_trx_type_id,
199: ar.name,
200: 4 default_term_id
201: FROM fun_system_options fun,
202: RA_CUST_TRX_TYPES_ALL ar,
203: AR_MEMO_LINES_ALL_VL m
204: WHERE fun.default_memo_line_id = m.memo_line_id
205: AND fun.default_ar_trx_type_id = ar.cust_trx_type_id

Line 217: FROM fun_system_options fun,

213: m.name,
214: ar.cust_trx_type_id,
215: ar.name,
216: null default_term_id
217: FROM fun_system_options fun,
218: RA_CUST_TRX_TYPES_ALL ar,
219: AR_MEMO_LINES_ALL_VL m
220: WHERE fun.default_memo_line_id = m.memo_line_id
221: AND fun.default_cm_trx_type_id = ar.cust_trx_type_id

Line 345: FROM fun_system_options fun,

341: CURSOR c_get_def ( p_org_id NUMBER,
342: p_trx_date DATE)
343: IS
344: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
345: FROM fun_system_options fun,
346: RA_CUST_TRX_TYPES_ALL ar
347: WHERE fun.default_ar_trx_type_id = ar.cust_trx_type_id
348: AND ar.org_id = p_org_id
349: AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);

Line 355: FROM fun_system_options fun,

351: CURSOR c_get_def_cm ( p_org_id NUMBER,
352: p_trx_date DATE)
353: IS
354: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
355: FROM fun_system_options fun,
356: RA_CUST_TRX_TYPES_ALL ar
357: WHERE fun.default_cm_trx_type_id = ar.cust_trx_type_id
358: AND ar.org_id = p_org_id
359: AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);