APPS.PQH_FR_ASSIGNMENT_CHK SQL Statements

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

Line: 18

Select null
from per_all_assignments_f asg,
     hr_soft_coding_keyflex scl
where asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
and   scl.segment23 = p_identifier;

Line: 48

select effective_start_date
from per_all_assignments_f assign
where effective_start_date > p_effective_date
and person_id = p_person_id
And assign.primary_flag = 'N';

Line: 87

Select Sum(nvl(scl.segment25,0)) Percenteffected
From  per_all_assignments_f assign,
      hr_soft_coding_keyflex scl
Where person_id = p_person_id
And assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
And assign.primary_flag = 'N'
And p_effective_date Between effective_start_date And effective_end_date
And assign.assignment_status_type_id = 1;

Line: 97

Select nvl(scl.segment25,0) Percenteffected
From  per_all_assignments_f assign,
      hr_soft_coding_keyflex scl
Where person_id = p_person_id
And assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
And assign.primary_flag = 'N'
And p_effective_date Between effective_start_date And effective_end_date
And assign.assignment_status_type_id = 1
and assign.assignment_id = p_assignment_id;

Line: 149

Select nvl(information1,'N')
from hr_all_positions_f
where position_id = p_position_id;

Line: 154

Select per_information15
from per_all_people_f
where person_id =p_person_id
and p_effective_date between effective_start_date and effective_end_date;

Line: 189

Select per_information15
from per_all_people_f
where person_id =p_person_id
and p_effective_date between effective_start_date and effective_end_date;

Line: 195

Select nvl(information1,'N')
from hr_all_positions_f
where position_id = p_position_id;

Line: 236

Select null
from per_all_assignments_f asg, hr_soft_coding_keyflex scl
where segment26 = p_admin_career_id
and segment27 ='Y'
and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
and p_effective_date between asg.effective_start_date and asg.effective_end_date
and asg.assignment_status_type_id <> 3;

Line: 247

Select effective_start_date
from per_all_assignments_f asg, hr_soft_coding_keyflex scl
where segment26 = p_admin_career_id
and segment27 ='Y'
and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
and asg.effective_start_date > p_effective_date;

Line: 280

Select per_information15
from per_all_people_f
where person_id =p_person_id
and p_effective_date between effective_start_date and effective_end_date;

Line: 286

select ss.situation_type
from pqh_fr_emp_stat_situations ess,
     pqh_fr_stat_situations_v ss
where person_id = p_person_id
  and p_effective_date between actual_start_date and nvl(actual_end_date,provisional_end_date)
  and ess.statutory_situation_id = ss.statutory_situation_id;