APPS.JL_CO_FA_TA_VALIDATE_PKG dependencies on FA_ADDITIONS

Line 45: fa_additions ad

41: a.asset_number appr_asset_number,
42: a.appraisal_value,
43: a.status
44: FROM jl_co_fa_asset_apprs a,
45: fa_additions ad
46: WHERE a.asset_number = ad.asset_number(+)
47: AND a.appraisal_id = p_appr_id
48: AND NVL(a.status, 'E') <> 'V'
49: FOR UPDATE OF status;