APPS.PQH_WORKFLOW dependencies on PER_POSITION_EXTRA_INFO

Line 197: from per_position_extra_info pei, hr_all_positions_f pos, per_all_assignments_f asg

193: and p_session_date between asg.effective_start_date and asg.effective_end_date;
194:
195: cursor c_get_pos_role(p_assignment_id number) is
196: select decode(information_type, 'PQH_POS_ROLE_ID' , to_number(poei_information3), -1) ROLE_ID
197: from per_position_extra_info pei, hr_all_positions_f pos, per_all_assignments_f asg
198: where pei.position_id=pos.position_id and pei.information_type='PQH_POS_ROLE_ID'
199: and pos.position_id = asg.position_id
200: and p_session_date between pos.effective_start_date and pos.effective_end_date
201: and p_session_date between asg.effective_start_date and asg.effective_end_date

Line 483: from per_position_extra_info pei

479: select employee_id from fnd_user
480: where user_id = p_user_id;
481: cursor c_position_role(p_position_id number) is
482: SELECT decode(information_type, 'PQH_POS_ROLE_ID' , to_number(poei_information3), -1) ROLE_ID
483: from per_position_extra_info pei
484: WHERE pei.position_id=p_position_id
485: and pei.information_type='PQH_POS_ROLE_ID';
486:
487: cursor c_asg_details(p_assignment_id number,l_person_id number) is