APPS.FA_C_INSURE dependencies on FA_ADJUSTMENTS

Line 310: FROM fa_adjustments adj,

306:
307: SELECT DECODE(adj.DEBIT_CREDIT_FLAG ,
308: 'CR', -1 * nvl(adj.adjustment_amount,0),
309: NVL(adj.adjustment_amount,0))
310: FROM fa_adjustments adj,
311: fa_transaction_headers fth,
312: fa_books bks
313: WHERE bks.date_ineffective is not null
314: AND fth.transaction_date_entered BETWEEN

Line 1338: FROM fa_adjustments adj

1334:
1335: SELECT SUM(DECODE(adj.DEBIT_CREDIT_FLAG ,
1336: 'CR', -1 * nvl(adj.adjustment_amount,0),
1337: NVL(adj.adjustment_amount,0)))
1338: FROM fa_adjustments adj
1339: WHERE adj.transaction_header_id = transaction_id
1340: AND adj.source_type_code = 'ADJUSTMENT'
1341: AND adj.adjustment_type = 'COST'
1342: AND adj.book_type_code = p_book_type_code