DBA Data[Home] [Help]

APPS.FA_TRANSFER_XIT_PKG dependencies on FA_TRANSACTION_HEADERS

Line 838: FA_TRANSACTION_HEADERS TH

834: DH.CODE_COMBINATION_ID,
835: DH.UNITS_ASSIGNED
836: FROM
837: FA_DISTRIBUTION_HISTORY DH,
838: FA_TRANSACTION_HEADERS TH
839: WHERE
840: TH.TRANSACTION_HEADER_ID = X_adj.selection_thid AND
841: (TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_IN OR
842: TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_OUT)

Line 1849: FA_TRANSACTION_HEADERS TH

1845: FROM
1846: FA_DEPRN_PERIODS DP_NOW,
1847: FA_DEPRN_PERIODS DP,
1848: FA_BOOK_CONTROLS BC,
1849: FA_TRANSACTION_HEADERS TH
1850: WHERE
1851: TH.ASSET_ID = X_asset_id AND
1852: TH.TRANSACTION_TYPE_CODE = DECODE(BC.BOOK_CLASS,'CORPORATE',
1853: 'TRANSFER IN','ADDITION') AND

Line 2181: from fa_transaction_headers

2177: l_sum_units_assigned;
2178:
2179: select transaction_header_id -- Bug 10387406
2180: into l_trx_header_id
2181: from fa_transaction_headers
2182: where asset_id = X_asset_id
2183: and book_type_code = X_book_type_code
2184: and transaction_type_code = 'ADDITION';
2185: