APPS.JL_CO_FA_TA_VALIDATE_PKG dependencies on JL_CO_FA_ASSET_APPRS

Line 44: FROM jl_co_fa_asset_apprs a,

40: SELECT ad.asset_number,
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'

Line 128: UPDATE jl_co_fa_asset_apprs

124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
125: END IF;
126:
127:
128: UPDATE jl_co_fa_asset_apprs
129: SET status = x_status
130: WHERE current of c_assets;
131:
132: x_status := 'V';