DBA Data[Home] [Help]

APPS.PQP_GB_PENSRV_SVPN SQL Statements

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

Line: 30

   l_query := 'select max(effective_start_date)'||' '||
              'from per_all_assignments_f '||' '||
              'where business_group_id = '||g_business_group_id||' '||
              'and assignment_id = '||p_assignment_id||' '||
              'and effective_start_date <= to_date('''||TO_CHAR(g_eff_end_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'') '||' '||
              'and effective_end_date >= to_date('''||TO_CHAR(g_eff_start_date,'dd/mm/yyyy')||''',''dd/mm/yyyy'')'||' '||
              'and '||g_asg_membership_col||' '||'IS NOT NULL'||' ';
Line: 66

   SELECT DISTINCT papf.national_identifier,papf.person_id,paaf.assignment_id,
          ppos.period_of_service_id,papf.employee_number,paaf.assignment_number
   FROM  per_all_people_f papf,
         per_all_assignments_f paaf,
	 per_periods_of_service ppos
   WHERE papf.business_group_id = g_business_group_id
   AND   papf.effective_start_date <= c_eff_end_date
   AND   papf.effective_end_date >= g_eff_start_date
   AND   papf.person_id = ppos.person_id
   AND   NVL(ppos.final_process_date,g_eff_start_date ) >= g_eff_start_date
   AND   ppos.period_of_service_id = paaf.period_of_service_id
   AND   paaf.PRIMARY_FLAG = 'Y'
   AND   paaf.business_group_id = g_business_group_id
   AND   paaf.effective_start_date <= c_eff_end_date
   AND   paaf.effective_end_date >= g_eff_start_date
   AND   paaf.effective_start_date = PQP_GB_PENSRV_SVPN.chk_emp_eligibility(paaf.assignment_id)
   ORDER BY papf.national_identifier,ppos.period_of_service_id;
Line: 88

   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 = g_business_group_id;
Line: 99

   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 = g_business_group_id;
Line: 110

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