DBA Data[Home] [Help]

APPS.HR_APPRAISALS_SWI dependencies on PER_APPRAISALS

Line 262: l_apr_status per_appraisals.appraisal_system_status%TYPE;

258: -- Variables for IN/OUT parameters
259: --
260: -- Other variables
261: l_proc varchar2(72) := g_package ||'delete_appraisal';
262: l_apr_status per_appraisals.appraisal_system_status%TYPE;
263: l_del_mode boolean;
264: l_del_status varchar2(10);
265: l_ovn per_appraisals.appraisal_id%TYPE;
266:

Line 265: l_ovn per_appraisals.appraisal_id%TYPE;

261: l_proc varchar2(72) := g_package ||'delete_appraisal';
262: l_apr_status per_appraisals.appraisal_system_status%TYPE;
263: l_del_mode boolean;
264: l_del_status varchar2(10);
265: l_ovn per_appraisals.appraisal_id%TYPE;
266:
267: -- Cursor to get the appraisal_system_status
268:
269: cursor cs_apr_status is

Line 271: from per_appraisals

267: -- Cursor to get the appraisal_system_status
268:
269: cursor cs_apr_status is
270: select appraisal_system_status
271: from per_appraisals
272: where appraisal_id= p_appraisal_id ;
273: --
274:
275: Begin