APPS.JL_CO_FA_TA_VALIDATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

    SELECT apr.appraisal_id,
           apr.fiscal_year,
           cur.currency_code
    FROM   jl_co_fa_appraisals apr,
           fnd_currencies_active_v cur
    WHERE  apr.appraisal_id = nvl (p_appraisal_id, apr.appraisal_id)
      AND  apr.currency_code = cur.currency_code(+)
      AND  appraisal_status NOT IN ('V','P')
    FOR UPDATE OF appraisal_status;

Line: 40

    SELECT ad.asset_number,
           a.asset_number appr_asset_number,
           a.appraisal_value,
           a.status
    FROM   jl_co_fa_asset_apprs a,
           fa_additions ad
    WHERE  a.asset_number = ad.asset_number(+)
      AND  a.appraisal_id = p_appr_id
      AND  NVL(a.status, 'E') <> 'V'
    FOR UPDATE OF status;

Line: 128

            UPDATE jl_co_fa_asset_apprs
            SET    status = x_status
            WHERE  current of c_assets;

Line: 137

      UPDATE jl_co_fa_appraisals
      SET    appraisal_status = x_appraisal_status
      WHERE  current of c_appraisals;