DBA Data[Home] [Help]

APPS.HR_APPRAISALS_SWI dependencies on PER_APPRAISALS

Line 258: l_apr_status per_appraisals.appraisal_system_status%TYPE;

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

Line 261: l_ovn per_appraisals.appraisal_id%TYPE;

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

Line 267: from per_appraisals

263: -- Cursor to get the appraisal_system_status
264:
265: cursor cs_apr_status is
266: select appraisal_system_status
267: from per_appraisals
268: where appraisal_id= p_appraisal_id ;
269: --
270:
271: Begin