APPS.CE_BAT_UTILS dependencies on CE_STATEMENT_LINES

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

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

Line 144: ce_statement_lines sl

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

Line 156: ce_statement_lines sl

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

Line 167: from ce_statement_lines sl

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

Line 197: from ce_statement_lines

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