APPS.CSE_FA_STAGE_PKG dependencies on CSI_FA_TRANSACTIONS

Line 200: SELECT csi_fa_transactions_s.nextval

196: IF p_asset_dist_tbl.COUNT > 0 THEN
197: FOR dist_ind IN p_asset_dist_tbl.FIRST .. p_asset_dist_tbl.LAST
198: LOOP
199:
200: SELECT csi_fa_transactions_s.nextval
201: INTO l_interface_line_id
202: FROM sys.dual;
203:
204: csi_fa_transactions_pkg.INSERT_ROW (

Line 204: csi_fa_transactions_pkg.INSERT_ROW (

200: SELECT csi_fa_transactions_s.nextval
201: INTO l_interface_line_id
202: FROM sys.dual;
203:
204: csi_fa_transactions_pkg.INSERT_ROW (
205: X_ROWID => l_rowid,
206: X_INTERFACE_LINE_ID => l_interface_line_id,
207: X_INTERFACE_HEADER_ID => l_interface_header_id,
208: X_DISTRIBUTION_ID => p_asset_dist_tbl(dist_ind).distribution_id,

Line 303: csi_fa_transactions cft,

299: cft.transaction_date,
300: cft.transaction_cost,
301: cfh.feeder_system_name
302: FROM csi_fa_headers cfh,
303: csi_fa_transactions cft,
304: fa_additions fa
305: WHERE cfh.status_code = 'NEW'
306: AND cft.interface_header_id = cfh.interface_header_id
307: AND cft.status_code = 'NEW'