DBA Data[Home] [Help]

APPS.FA_INV_XFR_PUB dependencies on FA_BOOKS

Line 106: FROM FA_BOOKS BK,FA_DEPRN_PERIODS DP

102: l_secondary_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
103:
104: CURSOR C_GET_SOURCE_GROUP IS
105: SELECT BK.GROUP_ASSET_ID
106: FROM FA_BOOKS BK,FA_DEPRN_PERIODS DP
107: WHERE BK.ASSET_ID = PX_SRC_ASSET_HDR_REC.ASSET_ID
108: AND BK.BOOK_TYPE_CODE = PX_SRC_ASSET_HDR_REC.BOOK_TYPE_CODE
109: AND BK.DATE_INEFFECTIVE IS NULL
110: AND BK.GROUP_ASSET_ID IS NOT NULL

Line 117: FROM FA_BOOKS BK,FA_DEPRN_PERIODS DP

113: AND DP.CALENDAR_PERIOD_OPEN_DATE > PX_SRC_TRANS_REC.AMORTIZATION_START_DATE;
114:
115: CURSOR C_GET_DEST_GROUP IS
116: SELECT BK.GROUP_ASSET_ID
117: FROM FA_BOOKS BK,FA_DEPRN_PERIODS DP
118: WHERE BK.ASSET_ID = PX_DEST_ASSET_HDR_REC.ASSET_ID
119: AND BK.BOOK_TYPE_CODE = PX_DEST_ASSET_HDR_REC.BOOK_TYPE_CODE
120: AND BK.DATE_INEFFECTIVE IS NULL
121: AND BK.GROUP_ASSET_ID IS NOT NULL