[Home] [Help]
1736: s.AUTHORIZATION_BAT,
1737: s.BSC_EXCHANGE_DATE_TYPE,
1738: s.BAT_EXCHANGE_DATE_TYPE,
1739: 1
1740: FROM CE_SYSTEM_PARAMETERS s
1741: WHERE s.legal_entity_id = CE_AUTO_BANK_MATCH.trx_legal_entity_id;
1742: */
1743: curr NUMBER;
1744: tx_type VARCHAR2(30);
2189: CE_AUTO_BANK_MATCH.trx_cleared_date,
2190: CE_AUTO_BANK_MATCH.trx_org_id,
2191: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2192: FROM gl_sets_of_books sob,
2193: ce_system_parameters sp,
2194: ce_statement_reconcils_all rec,
2195: ce_bank_acct_uses_ou_v aba,
2196: ce_bank_accounts ba,
2197: ce_bank_acct_uses_ou_v aba2,
2293: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
2294: CE_AUTO_BANK_MATCH.trx_org_id,
2295: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2296: FROM gl_sets_of_books sob,
2297: ce_system_parameters sp,
2298: ce_statement_reconcils_all rec,
2299: ce_bank_acct_uses_ou_v aba,
2300: ce_bank_accounts ba,
2301: ce_bank_acct_uses_ou_v aba2,
2486: CE_AUTO_BANK_MATCH.trx_cleared_date,
2487: CE_AUTO_BANK_MATCH.trx_org_id,
2488: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2489: FROM gl_sets_of_books sob,
2490: ce_system_parameters sp,
2491: ce_statement_reconcils_all rec,
2492: ce_bank_accounts ba,
2493: ce_bank_acct_uses_ou_v aba,
2494: ap_payment_history_all aph,
2581: CE_AUTO_BANK_MATCH.trx_exchange_rate_type,
2582: CE_AUTO_BANK_MATCH.trx_org_id,
2583: CE_AUTO_BANK_MATCH.trx_bank_acct_use_id
2584: FROM gl_sets_of_books sob,
2585: ce_system_parameters sp,
2586: ce_statement_reconcils_all rec,
2587: ce_bank_accounts ba,
2588: ce_bank_acct_uses_ou_v aba,
2589: ar_cash_receipt_history_all crh,
6942: OI_CLEAR_STATUS_OLD,
6943: FLOAT_HANDLING_FLAG_OLD,
6944: SHOW_VOID_PAYMENT_FLAG,
6945: OI_MATCHING_CODE_OLD
6946: FROM CE_SYSTEM_PARAMETERS;
6947:
6948: END IF;
6949: cep_standard.debug('<
7526: l_je_currency_code
7527: FROM
7528: GL_JE_LINES JEL,
7529: GL_SETS_OF_BOOKS SOB,
7530: CE_SYSTEM_PARAMETERS SYS,
7531: GL_JE_HEADERS JEH,
7532: GL_PERIOD_STATUSES GPS,
7533: XLA_DISTRIBUTION_LINKS XLA,
7534: XLA_AE_LINES XLL
7556: AND NOT EXISTS
7557: (SELECT NULL
7558: FROM
7559: CE_STATEMENT_RECONCILS_ALL CRE2,
7560: CE_SYSTEM_PARAMETERS SYS2
7561: WHERE JEL.JE_HEADER_ID = CRE2.JE_HEADER_ID
7562: AND JEL.JE_LINE_NUM = CRE2.REFERENCE_ID
7563: AND CRE2.STATUS_FLAG = 'M'
7564: AND NVL(CRE2.CURRENT_RECORD_FLAG,'Y') = 'Y');
9887: -- bug 3676745 1/20/05 Did not enter organization (le_id and org_id missing)
9888: -- use match org_id and legal_entity_id
9889: -- if CE_AUTO_BANK_REC.G_legal_entity_id is not null then it has already been set by ceabrdrb.pls
9890: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
9891: --bug 4914608 get owner LE info from ce_system_parameters
9892: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) THEN
9893: --IF (CE_AUTO_BANK_MATCH.bau_org_id is not null or CE_AUTO_BANK_MATCH.bau_legal_entity_id is not null) THEN
9894: IF (CE_AUTO_BANK_MATCH.ba_owner_le_id is not null) THEN
9895: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
9891: --bug 4914608 get owner LE info from ce_system_parameters
9892: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) THEN
9893: --IF (CE_AUTO_BANK_MATCH.bau_org_id is not null or CE_AUTO_BANK_MATCH.bau_legal_entity_id is not null) THEN
9894: IF (CE_AUTO_BANK_MATCH.ba_owner_le_id is not null) THEN
9895: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
9896: CE_AUTO_BANK_REC.G_set_of_books_id,
9897: CE_AUTO_BANK_REC.G_cashbook_begin_date,
9898: CE_AUTO_BANK_REC.G_show_cleared_flag,
9899: CE_AUTO_BANK_REC.G_show_void_payment_flag,
9917:
9918: -- bug 4914608 set bank account variables
9919: IF (CE_AUTO_BANK_MATCH.csh_bank_account_id is not null) THEN
9920:
9921: CE_SYSTEM_PARAMETERS1_PKG.ba_select_columns(CE_AUTO_BANK_MATCH.BA_ROWID,
9922: CE_AUTO_BANK_MATCH.ba_ap_amount_tolerance,
9923: CE_AUTO_BANK_MATCH.ba_ap_percent_tolerance,
9924: CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance,
9925: CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance,