DBA Data[Home] [Help]

APPS.FA_DELETION_PVT dependencies on FA_ADDITIONS_B

Line 42: from fa_additions_b

38:
39: --5738269
40: select count(1)
41: into l_count
42: from fa_additions_b
43: where parent_asset_id = px_asset_hdr_rec.asset_id;
44:
45: IF (l_count > 0) THEN
46: fa_srvr_msg.add_message

Line 111: FROM FA_ADDITIONS_B

107: p_asset_desc_rec.lease_id is not null) then
108:
109: SELECT count(*)
110: INTO l_count
111: FROM FA_ADDITIONS_B
112: WHERE LEASE_ID = p_asset_desc_rec.lease_id
113: AND ASSET_CATEGORY_ID =
114: ANY (SELECT CATEGORY_ID
115: FROM FA_CATEGORIES