DBA Data[Home] [Help]

APPS.CSE_FA_STAGE_PKG dependencies on CSI_FA_HEADERS

Line 219: SELECT csi_fa_headers_s.nextval

215: IF l_stage_flag THEN
216:
217: BEGIN
218:
219: SELECT csi_fa_headers_s.nextval
220: INTO l_interface_header_id
221: FROM sys.dual;
222:
223: csi_fa_headers_pkg.INSERT_ROW (

Line 223: csi_fa_headers_pkg.INSERT_ROW (

219: SELECT csi_fa_headers_s.nextval
220: INTO l_interface_header_id
221: FROM sys.dual;
222:
223: csi_fa_headers_pkg.INSERT_ROW (
224: X_ROWID => l_rowid,
225: X_INTERFACE_HEADER_ID => l_interface_header_id,
226: X_FA_ASSET_ID => p_asset_hdr_rec.asset_id,
227: X_FEEDER_SYSTEM_NAME => l_feeder_system_name,

Line 347: FROM csi_fa_headers cfh,

343: cft.transaction_units,
344: cft.transaction_date,
345: cft.transaction_cost,
346: cfh.feeder_system_name
347: FROM csi_fa_headers cfh,
348: csi_fa_transactions cft,
349: fa_additions fa
350: WHERE cfh.status_code = 'NEW'
351: AND cft.interface_header_id = cfh.interface_header_id