APPS.PER_CPN_BUS dependencies on PER_RATING_SCALES

Line 731: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE

727: --
728: procedure chk_rat_scale_bus_grp_exist
729: (p_competence_id in per_competences.competence_id%TYPE
730: ,p_object_version_number in per_competences.object_version_number%TYPE
731: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
732: ,p_business_group_id in per_competences.business_group_id%TYPE default null
733: )
734: is
735: --

Line 739: l_business_group_id per_rating_scales.business_group_id%TYPE;

735: --
736: l_exists varchar2(1);
737: l_api_updating boolean;
738: l_proc varchar2(72) := g_package||'chk_rat_scale_bus_grp_exist';
739: l_business_group_id per_rating_scales.business_group_id%TYPE;
740: --
741: --
742: -- Cursor to check if rating scale exists
743: --

Line 747: from per_rating_scales

743: --
744: Cursor csr_rat_scale_bus_grp_exist
745: is
746: select business_group_id
747: from per_rating_scales
748: where rating_scale_id = p_rating_scale_id;
749: --
750: --
751: begin

Line 833: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE

829: --
830: procedure chk_rating_scale_type
831: (p_competence_id in per_competences.competence_id%TYPE
832: ,p_object_version_number in per_competences.object_version_number%TYPE
833: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
834: )
835: is
836: --
837: l_exists varchar2(1);

Line 847: from per_rating_scales

843: --
844: Cursor csr_chk_rating_scale_type
845: is
846: select 'Y'
847: from per_rating_scales
848: where rating_scale_id = p_rating_scale_id
849: and upper(type) = 'PROFICIENCY';
850: --
851: --

Line 921: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE

917: --
918: procedure chk_competence_has_prof
919: (p_competence_id in per_competences.competence_id%TYPE
920: ,p_object_version_number in per_competences.object_version_number%TYPE
921: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
922: )
923: is
924: --
925: l_exists varchar2(1);