eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_ASSIGNMENT_CHK dependencies on PER_ALL_PEOPLE_F

Line 155: from per_all_people_f

151: where position_id = p_position_id;
152: --
153: Cursor csr_person_info IS
154: Select per_information15
155: from per_all_people_f
156: where person_id =p_person_id
157: and p_effective_date between effective_start_date and effective_end_date;
158: ---
159: l_titulaire_pos varchar2(10);

Line 190: from per_all_people_f

186: procedure chk_type(p_type in varchar2, p_person_id in Number, p_effective_date in DATE,p_position_id in Number)
187: IS
188: Cursor csr_person_info IS
189: Select per_information15
190: from per_all_people_f
191: where person_id =p_person_id
192: and p_effective_date between effective_start_date and effective_end_date;
193: --
194: Cursor csr_tit_pos IS

Line 281: from per_all_people_f

277: IS
278:
279: Cursor csr_person_info IS
280: Select per_information15
281: from per_all_people_f
282: where person_id =p_person_id
283: and p_effective_date between effective_start_date and effective_end_date;
284:
285: Cursor csr_situation_info IS