APPS.CSE_FA_STAGE_PKG dependencies on CSI_FA_HEADERS

Line 174: SELECT csi_fa_headers_s.nextval

170: IF l_stage_flag THEN
171:
172: BEGIN
173:
174: SELECT csi_fa_headers_s.nextval
175: INTO l_interface_header_id
176: FROM sys.dual;
177:
178: csi_fa_headers_pkg.INSERT_ROW (

Line 178: csi_fa_headers_pkg.INSERT_ROW (

174: SELECT csi_fa_headers_s.nextval
175: INTO l_interface_header_id
176: FROM sys.dual;
177:
178: csi_fa_headers_pkg.INSERT_ROW (
179: X_ROWID => l_rowid,
180: X_INTERFACE_HEADER_ID => l_interface_header_id,
181: X_FA_ASSET_ID => p_asset_hdr_rec.asset_id,
182: X_FEEDER_SYSTEM_NAME => l_feeder_system_name,

Line 302: FROM csi_fa_headers cfh,

298: cft.transaction_units,
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