APPS.PQH_FR_ASSIGNMENT_CHK dependencies on HR_ALL_POSITIONS_F

Line 150: from hr_all_positions_f

146: IS
147:
148: Cursor csr_tit_pos IS
149: Select nvl(information1,'N')
150: from hr_all_positions_f
151: where position_id = p_position_id;
152: --
153: Cursor csr_person_info IS
154: Select per_information15

Line 196: from hr_all_positions_f

192: and p_effective_date between effective_start_date and effective_end_date;
193: --
194: Cursor csr_tit_pos IS
195: Select nvl(information1,'N')
196: from hr_all_positions_f
197: where position_id = p_position_id;
198: --
199: l_agent_type varchar2(10);
200: l_titulaire_pos varchar2(10);