APPS.CE_AUTO_BANK_MATCH dependencies on GL_DAILY_CONVERSION_TYPES

Line 5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,

5529: ar.trx_date,
5530: v.org_id,
5531: v.CE_BANK_ACCT_USE_ID,
5532: v.seq_id
5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5535: ar_cash_receipt_history_all ar, ce_statement_headers h,
5536: ce_statement_reconcils_all r, ce_statement_lines l
5537: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,

5530: v.org_id,
5531: v.CE_BANK_ACCT_USE_ID,
5532: v.seq_id
5533: --FROM ce_222_transactions_v v, gl_daily_conversion_types glcc,
5534: FROM ce_available_transactions_tmp v, gl_daily_conversion_types glcc,
5535: ar_cash_receipt_history_all ar, ce_statement_headers h,
5536: ce_statement_reconcils_all r, ce_statement_lines l
5537: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5538: AND nvl(l.bank_trx_number,'-9999') =

Line 5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,

5644: to_date(NULL),
5645: v2.org_id,
5646: v2.CE_BANK_ACCT_USE_ID,
5647: v2.seq_id
5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5650: ce_statement_headers h,
5651: ce_statement_reconcils_all r, ce_statement_lines l
5652: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id

Line 5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,

5645: v2.org_id,
5646: v2.CE_BANK_ACCT_USE_ID,
5647: v2.seq_id
5648: --FROM ce_200_transactions_v v2, gl_daily_conversion_types glcc,
5649: FROM ce_available_transactions_tmp v2, gl_daily_conversion_types glcc,
5650: ce_statement_headers h,
5651: ce_statement_reconcils_all r, ce_statement_lines l
5652: WHERE h.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5653: AND nvl(l.bank_trx_number,'-9999') =