APPS.PER_OBJ_BUS dependencies on PER_APPRAISALS

Line 109: from per_appraisals

105: --
106: Cursor csr_appraisal_exists
107: is
108: select business_group_id
109: from per_appraisals
110: where appraisal_id = p_appraisal_id;
111: --
112: begin
113: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 187: (p_appraisal_id per_appraisals.appraisal_id%TYPE

183: -- Internal Table Handler Use Only.
184: --
185: --
186: procedure chk_upd_appraisal
187: (p_appraisal_id per_appraisals.appraisal_id%TYPE
188: )
189: is
190: --
191: l_exists varchar2(1);

Line 238: -- equals to the appraisee_id in per_appraisals.

234: -- - Validates that the person is in the same business group as the
235: -- objective
236: -- - Validates that the person is valid as of the effective date
237: -- - Validates that if an appraisal_id is entered then the owning_person_id
238: -- equals to the appraisee_id in per_appraisals.
239: --
240: -- Pre_conditions:
241: -- - Valid Business_group_id
242: --

Line 260: -- -- owning_person_id does to equal to appraisee_id in per_appraisals

256: -- -- owning_person_id is not set
257: -- -- effective_date is not set
258: -- -- person does not exist in the business group
259: -- -- person does not exist as of effective date
260: -- -- owning_person_id does to equal to appraisee_id in per_appraisals
261: -- if appraisal_id is entered.
262: --
263: -- Access Status
264: -- Internal Table Handler Use Only.

Line 302: -- the appraisee_id in per_appraisals

298: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
299: --
300: --
301: -- Cursor to check if the owning_person_id is equal to
302: -- the appraisee_id in per_appraisals
303: --
304: Cursor csr_owned_by_person
305: is
306: select 'Y'

Line 307: from per_appraisals

303: --
304: Cursor csr_owned_by_person
305: is
306: select 'Y'
307: from per_appraisals
308: where appraisal_id = p_appraisal_id
309: and appraisee_person_id = p_owning_person_id;
310: --
311: begin

Line 372: -- check if owning_person_id = appraisee_id in per_appraisals

368: end if;
369:
370: hr_utility.set_location(l_proc, 5);
371: /*
372: -- check if owning_person_id = appraisee_id in per_appraisals
373: -- Only perform the check if the appraisal_id is populated
374: if p_appraisal_id is not null then
375: open csr_owned_by_person;
376: fetch csr_owned_by_person into l_exists;

Line 563: from per_appraisals appr,

559: --
560: cursor csr_is_new_appraisal
561: is
562: select 'Y'
563: from per_appraisals appr,
564: per_appraisal_templates templ
565: where appr.appraisal_id = p_appraisal_id
566: and appr.appraisal_template_id = templ.appraisal_template_id
567: and templ.objective_asmnt_type_id is not null;

Line 2047: ,per_appraisals ap

2043: FROM
2044: per_objectives pobj
2045: ,per_personal_scorecards ppsc
2046: ,per_personal_scorecards ppsc2
2047: ,per_appraisals ap
2048: WHERE
2049: pobj.objective_id = p_aligned_with_obj_id
2050: AND pobj.scorecard_id = ppsc.scorecard_id (+)
2051: AND pobj.appraisal_id = ap.appraisal_id (+)