APPS.FA_C_INSURE dependencies on FA_ADJUSTMENTS

Line 300: FROM fa_adjustments adj,

296:
297: SELECT DECODE(adj.DEBIT_CREDIT_FLAG ,
298: 'CR', -1 * nvl(adj.adjustment_amount,0),
299: NVL(adj.adjustment_amount,0))
300: FROM fa_adjustments adj,
301: fa_transaction_headers fth,
302: fa_books bks
303: WHERE bks.date_ineffective is not null
304: AND fth.transaction_date_entered BETWEEN

Line 1348: FROM fa_adjustments adj

1344:
1345: SELECT SUM(DECODE(adj.DEBIT_CREDIT_FLAG ,
1346: 'CR', -1 * nvl(adj.adjustment_amount,0),
1347: NVL(adj.adjustment_amount,0)))
1348: FROM fa_adjustments adj
1349: WHERE adj.transaction_header_id = transaction_id
1350: AND adj.source_type_code = 'ADJUSTMENT'
1351: AND adj.adjustment_type = 'COST'
1352: AND adj.book_type_code = p_book_type_code