APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_ADJUSTMENTS

Line 1029: INSERT INTO FA_ADJUSTMENTS(

1025: and book_type_code = p_asset_hdr_rec.book_type_code
1026: and transaction_header_id = l_thid
1027: ;
1028:
1029: INSERT INTO FA_ADJUSTMENTS(
1030: TRANSACTION_HEADER_ID
1031: , SOURCE_TYPE_CODE
1032: , ADJUSTMENT_TYPE
1033: , DEBIT_CREDIT_FLAG

Line 1112: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID

1108: , GLOBAL_ATTRIBUTE20
1109: , GLOBAL_ATTRIBUTE_CATEGORY
1110: , DEPRN_OVERRIDE_FLAG
1111: , TRACK_MEMBER_FLAG
1112: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
1113: , SOURCE_LINE_ID
1114: , SOURCE_DEST_CODE
1115: from fa_adjustments
1116: where asset_id = p_asset_hdr_rec.asset_id

Line 1115: from fa_adjustments

1111: , TRACK_MEMBER_FLAG
1112: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
1113: , SOURCE_LINE_ID
1114: , SOURCE_DEST_CODE
1115: from fa_adjustments
1116: where asset_id = p_asset_hdr_rec.asset_id
1117: and book_type_code = p_asset_hdr_rec.book_type_code
1118: and transaction_header_id = l_thid
1119: ;

Line 1212: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID

1208: , GLOBAL_ATTRIBUTE20
1209: , GLOBAL_ATTRIBUTE_CATEGORY
1210: , DEPRN_OVERRIDE_FLAG
1211: , TRACK_MEMBER_FLAG
1212: , fa_adjustments_s.nextval -- ADJUSTMENT_LINE_ID
1213: , SOURCE_LINE_ID
1214: , SOURCE_DEST_CODE
1215: from fa_mc_adjustments
1216: where asset_id = p_asset_hdr_rec.asset_id

Line 1392: delete from fa_adjustments

1388: if (p_mrc_sob_type_code <> 'R') then
1389: delete from fa_transaction_headers
1390: where transaction_header_id = l_thid;
1391:
1392: delete from fa_adjustments
1393: where asset_id = p_asset_hdr_rec.asset_id
1394: and book_type_code = p_asset_hdr_rec.book_type_code
1395: and transaction_header_id = l_thid;
1396: