eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_BAT_UTILS dependencies on CE_STATEMENT_LINES

Line 88: | rate/date/type from ce_statement_lines will be populated. |

84: | Returns the cashflow exchange date and cashflow exchange rate |
85: | In case of zba if its foreign scenario then if date type in |
86: | AVD or CLD then rate and date is null otherwise corresponding |
87: | rate will be populated. If international sceanrio then |
88: | rate/date/type from ce_statement_lines will be populated. |
89: | If bat/cl then in foreign scenario if date type in CFD or TRX |
90: | then corresponding date and rate is populated else rate and date |
91: | will be null |
92: ------------------------------------------------------------------------*/

Line 142: ce_statement_lines sl

138: begin
139: select statement_date
140: into p_exch_date
141: from ce_statement_headers sh,
142: ce_statement_lines sl
143: where sh.statement_header_id = sl.statement_header_id
144: and sl.statement_line_id = G_created_from_stmtline_id;
145: exception
146: when others then

Line 154: ce_statement_lines sl

150: begin
151: select gl_date
152: into p_exch_date
153: from ce_statement_headers sh,
154: ce_statement_lines sl
155: where sh.statement_header_id = sl.statement_header_id
156: and sl.statement_line_id = G_created_from_stmtline_id;
157: exception
158: when others then

Line 165: from ce_statement_lines sl

161: elsif (p_exchange_date_type = 'SLD') then
162: begin
163: select trx_date
164: into p_exch_date
165: from ce_statement_lines sl
166: where sl.statement_line_id = G_created_from_stmtline_id;
167: exception
168: when others then
169: null;

Line 195: from ce_statement_lines

191: exchange_rate_date
192: into p_exch_rate,
193: p_exch_type,
194: p_exch_date
195: from ce_statement_lines
196: where statement_line_id = G_created_from_stmtline_id;
197:
198: exception
199: when others then

Line 594: l_stmt_line_trx_type ce_statement_lines.trx_type%type;

590: min_acct_unit number default null;
591: -- Bug 8358259 end
592:
593: -- Bug 14731000: Start
594: l_stmt_line_trx_type ce_statement_lines.trx_type%type;
595: l_pay_stmt_line_id ce_statement_lines.statement_line_id%type;
596: l_rec_stmt_line_id ce_statement_lines.statement_line_id%type;
597: l_cf1_stmt_line_id ce_statement_lines.statement_line_id%type;
598: l_cf2_stmt_line_id ce_statement_lines.statement_line_id%type;

Line 595: l_pay_stmt_line_id ce_statement_lines.statement_line_id%type;

591: -- Bug 8358259 end
592:
593: -- Bug 14731000: Start
594: l_stmt_line_trx_type ce_statement_lines.trx_type%type;
595: l_pay_stmt_line_id ce_statement_lines.statement_line_id%type;
596: l_rec_stmt_line_id ce_statement_lines.statement_line_id%type;
597: l_cf1_stmt_line_id ce_statement_lines.statement_line_id%type;
598: l_cf2_stmt_line_id ce_statement_lines.statement_line_id%type;
599: -- Bug 14731000: End

Line 596: l_rec_stmt_line_id ce_statement_lines.statement_line_id%type;

592:
593: -- Bug 14731000: Start
594: l_stmt_line_trx_type ce_statement_lines.trx_type%type;
595: l_pay_stmt_line_id ce_statement_lines.statement_line_id%type;
596: l_rec_stmt_line_id ce_statement_lines.statement_line_id%type;
597: l_cf1_stmt_line_id ce_statement_lines.statement_line_id%type;
598: l_cf2_stmt_line_id ce_statement_lines.statement_line_id%type;
599: -- Bug 14731000: End
600:

Line 597: l_cf1_stmt_line_id ce_statement_lines.statement_line_id%type;

593: -- Bug 14731000: Start
594: l_stmt_line_trx_type ce_statement_lines.trx_type%type;
595: l_pay_stmt_line_id ce_statement_lines.statement_line_id%type;
596: l_rec_stmt_line_id ce_statement_lines.statement_line_id%type;
597: l_cf1_stmt_line_id ce_statement_lines.statement_line_id%type;
598: l_cf2_stmt_line_id ce_statement_lines.statement_line_id%type;
599: -- Bug 14731000: End
600:
601: BEGIN

Line 598: l_cf2_stmt_line_id ce_statement_lines.statement_line_id%type;

594: l_stmt_line_trx_type ce_statement_lines.trx_type%type;
595: l_pay_stmt_line_id ce_statement_lines.statement_line_id%type;
596: l_rec_stmt_line_id ce_statement_lines.statement_line_id%type;
597: l_cf1_stmt_line_id ce_statement_lines.statement_line_id%type;
598: l_cf2_stmt_line_id ce_statement_lines.statement_line_id%type;
599: -- Bug 14731000: End
600:
601: BEGIN
602: log('>>CE_BAT_UTILS.transfer_payment_transaction');

Line 636: FROM CE_STATEMENT_LINES

632: THEN
633: BEGIN
634: SELECT trx_type
635: INTO l_stmt_line_trx_type
636: FROM CE_STATEMENT_LINES
637: WHERE STATEMENT_LINE_ID = G_created_from_stmtline_id;
638:
639: log('trx_type='||l_stmt_line_trx_type);
640: IF (l_stmt_line_trx_type = 'SWEEP_IN')