DBA Data[Home] [Help]

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_RETIREMENTS

Line 2036: FROM fa_retirements ret

2032: l_ignore_retirement := 'N';
2033: BEGIN
2034: SELECT 'Y'
2035: INTO l_ignore_retirement
2036: FROM fa_retirements ret
2037: WHERE ret.book_type_code = asset_txns_rec.book_type_code
2038: AND ret.asset_id = asset_txns_rec.asset_id
2039: AND ret.transaction_header_id_in = asset_txns_rec.transaction_header_id
2040: AND ret.status = 'DELETED'

Line 2108: FROM fa_retirements ret

2104: l_ignore_reinstatement := 'N';
2105: BEGIN
2106: SELECT 'Y'
2107: INTO l_ignore_reinstatement
2108: FROM fa_retirements ret
2109: WHERE ret.book_type_code = asset_txns_rec.book_type_code
2110: AND ret.asset_id = asset_txns_rec.asset_id
2111: AND ret.transaction_header_id_out = asset_txns_rec.transaction_header_id
2112: AND ret.status = 'DELETED'