APPS.PER_CPN_BUS dependencies on PER_RATING_SCALES

Line 725: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE

721: --
722: procedure chk_rat_scale_bus_grp_exist
723: (p_competence_id in per_competences.competence_id%TYPE
724: ,p_object_version_number in per_competences.object_version_number%TYPE
725: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
726: ,p_business_group_id in per_competences.business_group_id%TYPE default null
727: )
728: is
729: --

Line 733: l_business_group_id per_rating_scales.business_group_id%TYPE;

729: --
730: l_exists varchar2(1);
731: l_api_updating boolean;
732: l_proc varchar2(72) := g_package||'chk_rat_scale_bus_grp_exist';
733: l_business_group_id per_rating_scales.business_group_id%TYPE;
734: --
735: --
736: -- Cursor to check if rating scale exists
737: --

Line 741: from per_rating_scales

737: --
738: Cursor csr_rat_scale_bus_grp_exist
739: is
740: select business_group_id
741: from per_rating_scales
742: where rating_scale_id = p_rating_scale_id;
743: --
744: --
745: begin

Line 827: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE

823: --
824: procedure chk_rating_scale_type
825: (p_competence_id in per_competences.competence_id%TYPE
826: ,p_object_version_number in per_competences.object_version_number%TYPE
827: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
828: )
829: is
830: --
831: l_exists varchar2(1);

Line 841: from per_rating_scales

837: --
838: Cursor csr_chk_rating_scale_type
839: is
840: select 'Y'
841: from per_rating_scales
842: where rating_scale_id = p_rating_scale_id
843: and upper(type) = 'PROFICIENCY';
844: --
845: --

Line 915: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE

911: --
912: procedure chk_competence_has_prof
913: (p_competence_id in per_competences.competence_id%TYPE
914: ,p_object_version_number in per_competences.object_version_number%TYPE
915: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
916: )
917: is
918: --
919: l_exists varchar2(1);