APPS.PER_APT_BUS dependencies on PER_APPRAISALS

Line 213: from per_appraisals apr

209: l_proc varchar2(72):=g_package||'chk_template_dates';
210:
211: Cursor csr_check_dates_in_apr is
212: select 'Y'
213: from per_appraisals apr
214: where ( apr.appraisal_period_start_date < nvl(p_date_from,hr_api.g_sot)
215: or apr.appraisal_period_end_date > nvl(p_date_to,hr_api.g_eot)
216: )
217: and apr.appraisal_template_id = p_appraisal_template_id;

Line 604: -- from per_appraisals apr

600:
601: -- Cursor csr_question_update
602: -- is
603: -- select 'Y'
604: -- from per_appraisals apr
605: -- ,per_assign_proposal_answers apa
606: -- where apr.appraisal_id = apa.answer_for_key
607: -- and apa.type = 'APPRAISAL'
608: -- and apr.appraisal_template_id = p_appraisal_template_id;

Line 617: from per_appraisals apr

613: select 'Y'
614: from hr_quest_answers hqa
615: where hqa.type = 'APPRAISAL'
616: and hqa.type_object_id in (select appraisal_id
617: from per_appraisals apr
618: where apr.appraisal_template_id
619: = p_appraisal_template_id);
620: -- Cursor to check if questionnaire template can be updated,
621: -- according to per_participants.

Line 625: where par.participation_in_table = 'PER_APPRAISALS'

621: -- according to per_participants.
622: cursor csr_question_update2 is
623: select 'Y'
624: from per_participants par
625: where par.participation_in_table = 'PER_APPRAISALS'
626: and par.participation_in_id in (select appraisal_id
627: from per_appraisals apr
628: where apr.appraisal_template_id
629: = p_appraisal_template_id);

Line 627: from per_appraisals apr

623: select 'Y'
624: from per_participants par
625: where par.participation_in_table = 'PER_APPRAISALS'
626: and par.participation_in_id in (select appraisal_id
627: from per_appraisals apr
628: where apr.appraisal_template_id
629: = p_appraisal_template_id);
630:
631: begin

Line 793: -- from per_appraisals apr

789:
790: -- Cursor csr_question_update
791: -- is
792: -- select 'Y'
793: -- from per_appraisals apr
794: -- ,per_assign_proposal_answers apa
795: -- where apr.appraisal_id = apa.answer_for_key
796: -- and apa.type = 'APPRAISAL'
797: -- and apr.appraisal_template_id = p_appraisal_template_id;

Line 806: from per_appraisals apr

802: select 'Y'
803: from hr_quest_answers hqa
804: where hqa.type = 'APPRAISAL'
805: and hqa.type_object_id in (select appraisal_id
806: from per_appraisals apr
807: where apr.appraisal_template_id
808: = p_appraisal_template_id);
809: -- Cursor to check if questionnaire template can be updated,
810: -- according to per_participants.

Line 814: where par.participation_in_table = 'PER_APPRAISALS'

810: -- according to per_participants.
811: cursor csr_question_update2 is
812: select 'Y'
813: from per_participants par
814: where par.participation_in_table = 'PER_APPRAISALS'
815: and par.participation_in_id in (select appraisal_id
816: from per_appraisals apr
817: where apr.appraisal_template_id
818: = p_appraisal_template_id);

Line 816: from per_appraisals apr

812: select 'Y'
813: from per_participants par
814: where par.participation_in_table = 'PER_APPRAISALS'
815: and par.participation_in_id in (select appraisal_id
816: from per_appraisals apr
817: where apr.appraisal_template_id
818: = p_appraisal_template_id);
819:
820: begin

Line 964: l_overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE;

960: l_api_updating boolean;
961: l_proc varchar2(72) := g_package||'chk_rating_scale';
962: l_type per_rating_scales.type%TYPE;
963: l_business_group_id per_appraisal_templates.business_group_id%TYPE;
964: l_overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE;
965:
966:
967: -- Cursor to check if rating scale exists and get
968: -- the type

Line 983: from per_appraisals

979:
980: Cursor csr_rating_scale_update1
981: is
982: select overall_performance_level_id
983: from per_appraisals
984: where appraisal_template_id = p_appraisal_template_id;
985:
986: -- Cursor to check if the appraisal template
987: -- is used in appraisal which is further used in

Line 993: from per_appraisals apr

989:
990: Cursor csr_rating_scale_update2
991: is
992: select 'Y'
993: from per_appraisals apr
994: ,per_performance_ratings prt
995: where prt.appraisal_id = apr.appraisal_id
996: and apr.appraisal_template_id = p_appraisal_template_id;
997:

Line 1166: from per_appraisals

1162:
1163: Cursor csr_template_delete
1164: is
1165: select 'Y'
1166: from per_appraisals
1167: where appraisal_template_id = p_appraisal_template_id;
1168:
1169: begin
1170: hr_utility.set_location('Entering:'|| l_proc, 1);