APPS.PER_COMPETENCE_DATA_PUMP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

       SELECT rating_scale_id
       INTO   l_rating_scale_id
       FROM   per_rating_scales
       WHERE  name = p_old_rating_scale_name
       AND    business_group_id is null;

Line: 44

       SELECT rating_scale_id
       INTO   l_rating_scale_id
       FROM   per_rating_scales
       WHERE  name = p_old_rating_scale_name
       AND    business_group_id = p_business_group_id;

Line: 87

       SELECT rating_scale_id
       INTO   l_rating_scale_id
       FROM   per_rating_scales
       WHERE  name = p_rating_scale_name
       AND    business_group_id is null;

Line: 95

       SELECT rating_scale_id
       INTO   l_rating_scale_id
       FROM   per_rating_scales
       WHERE  name = p_rating_scale_name
       AND    business_group_id = p_business_group_id;

Line: 143

       SELECT object_version_number
       INTO   l_rsc_ovn
       FROM   per_rating_scales
       WHERE  name = p_old_rating_scale_name
       AND    business_group_id is null;

Line: 151

       SELECT object_version_number
       INTO   l_rsc_ovn
       FROM   per_rating_scales
       WHERE  name = p_old_rating_scale_name
       AND    business_group_id = p_business_group_id;

Line: 213

       SELECT competence_id
       INTO   l_competence_id
       FROM   per_competences_vl
       WHERE  name = p_competence_name
       AND    business_group_id is null;

Line: 221

       SELECT competence_id
       INTO   l_competence_id
       FROM   per_competences_vl
       WHERE  name = p_competence_name
       AND    business_group_id = p_business_group_id;

Line: 267

       SELECT object_version_number
       INTO   l_cpn_ovn
       FROM   per_competences_vl
       WHERE  name = p_competence_name
       AND    business_group_id is null;

Line: 275

       SELECT object_version_number
       INTO   l_cpn_ovn
       FROM   per_competences_vl
       WHERE  name = p_competence_name
       AND    business_group_id = p_business_group_id;

Line: 483

       SELECT rtl.rating_level_id
       INTO   l_rating_level_id
       FROM   per_rating_scales  rsc , per_rating_levels rtl
       WHERE  rtl.name = p_old_rating_level_name
       AND    rsc.rating_scale_id = rtl.rating_scale_id
	  AND    rsc.name = p_rating_scale_name
	  AND    NVL(rsc.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
	  AND    NVL(rsc.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);

Line: 494

       SELECT rtl.rating_level_id
       INTO   l_rating_level_id
       FROM   per_competences_vl  cpn , per_rating_levels rtl
       WHERE  rtl.name = p_old_rating_level_name
       AND    cpn.competence_id = rtl.competence_id
	  AND    cpn.name = p_competence_name
	  AND    NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
	  AND    NVL(cpn.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);

Line: 546

       SELECT rtl.rating_level_id
       INTO   l_rating_level_id
       FROM   per_rating_scales  rsc , per_rating_levels rtl
       WHERE  rtl.name = p_rating_level_name
       AND    rsc.rating_scale_id = rtl.rating_scale_id
	  AND    rsc.name = p_rating_scale_name
	  AND    NVL(rsc.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
	  AND    NVL(rsc.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);

Line: 557

       SELECT rtl.rating_level_id
       INTO   l_rating_level_id
       FROM   per_competences_vl  cpn , per_rating_levels rtl
       WHERE  rtl.name = p_rating_level_name
       AND    cpn.competence_id = rtl.competence_id
	  AND    cpn.name = p_competence_name
	  AND    NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
	  AND    NVL(cpn.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);

Line: 610

       SELECT rtl.object_version_number
       INTO   l_rtl_ovn
       FROM   per_rating_scales  rsc , per_rating_levels rtl
       WHERE  rtl.name = p_old_rating_level_name
       AND    rsc.rating_scale_id = rtl.rating_scale_id
	  AND    rsc.name = p_rating_scale_name
	  AND    NVL(rsc.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
	  AND    NVL(rsc.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);

Line: 621

       SELECT rtl.object_version_number
       INTO   l_rtl_ovn
       FROM   per_competences_vl  cpn , per_rating_levels rtl
       WHERE  rtl.name = p_old_rating_level_name
       AND    cpn.competence_id = rtl.competence_id
	  AND    cpn.name = p_competence_name
	  AND    NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)
	  AND    NVL(cpn.business_group_id,hr_api_g_number) = NVL(p_business_group_id,hr_api_g_number);

Line: 702

       SELECT qualification_type_id
       INTO   l_qualification_type_id
       FROM   per_qualification_types_vl
       WHERE  name = p_qualification_type_name;