APPS.PER_GB_PENSRV_SVPN SQL Statements

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

Line: 43

  SELECT business_group_id
  FROM   per_all_assignments_f
  WHERE  assignment_id = c_assignment_id
  AND    c_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 53

  SELECT pcv_information1,pcv_information2
  FROM   pqp_configuration_values pcv,
         pqp_configuration_types pct
  WHERE  pcv.pcv_information_category = pct.configuration_type
  AND    pct.configuration_type = 'PQP_GB_PENSERVER_ELIGBLTY_CONF'
  AND    pcv.business_group_id = c_business_group_id;

Line: 65

  SELECT aei_information1
  FROM   per_assignment_Extra_info
  WHERE  assignment_id = c_assignment_id
  AND    aei_information_category = 'PQP_GB_PENSERV_SVPN';

Line: 74

  SELECT max(to_number(paei.aei_information1))+1
  FROM  per_all_people_f papf,
        per_all_assignments_f paaf,
        per_assignment_extra_info paei
  WHERE papf.NATIONAL_IDENTIFIER = c_ni_number
  AND   papf.person_id = paaf.person_id
  AND   paei.assignment_id = paaf.assignment_id
  AND   paei.aei_information_category = 'PQP_GB_PENSERV_SVPN';

Line: 87

  SELECT papf1.NATIONAL_IDENTIFIER
  FROM  per_all_people_f papf1,
        per_all_assignments_f paaf1
  WHERE paaf1.assignment_id = c_assignment_id
  AND   c_effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
  AND   papf1.person_id = paaf1.person_id
  AND   c_effective_date BETWEEN papf1.effective_start_date AND papf1.effective_end_date;

Line: 99

  SELECT pcv_information4
  FROM  pqp_configuration_values pcv,
        pqp_configuration_types pct
  WHERE pcv.pcv_information_category = pct.configuration_type
  AND   pct.configuration_type = 'PQP_GB_PENSERVER_PAYPOINT_INFO'
  AND   pcv.business_group_id = c_business_group_id;

Line: 110

  SELECT paaf.primary_flag
  FROM  per_all_assignments_f paaf
  WHERE paaf.assignment_id = c_assignment_id
  AND   c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;

Line: 162

       l_query :=   'select '||l_column_name||' '||
                    'from per_all_assignments_f'||' '||
                    'where business_group_id = '||l_bg_id||' '||
                    'and assignment_id = '||g_assignment_id||' ';

Line: 222

             hr_utility.set_location(' inserted successfully :'||l_spn, 100);