APPS.JL_CO_FA_TA_VALIDATE_PKG dependencies on JL_CO_FA_APPRAISALS

Line 32: FROM jl_co_fa_appraisals apr,

28: CURSOR c_appraisals IS
29: SELECT apr.appraisal_id,
30: apr.fiscal_year,
31: cur.currency_code
32: FROM jl_co_fa_appraisals apr,
33: fnd_currencies_active_v cur
34: WHERE apr.appraisal_id = nvl (p_appraisal_id, apr.appraisal_id)
35: AND apr.currency_code = cur.currency_code(+)
36: AND appraisal_status NOT IN ('V','P')

Line 137: UPDATE jl_co_fa_appraisals

133:
134: END LOOP;
135:
136:
137: UPDATE jl_co_fa_appraisals
138: SET appraisal_status = x_appraisal_status
139: WHERE current of c_appraisals;
140:
141: x_appraisal_status := 'V';