The following lines contain the word 'select', 'insert', 'update' or 'delete':
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'||' ';
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;
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;
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;
SELECT aei_information_category
FROM per_assignment_Extra_info
WHERE assignment_id = c_assignment_id
AND aei_information_category = 'PQP_GB_PENSERV_SVPN';