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_WORKFLOW dependencies on HR_ALL_POSITIONS_F

Line 169: l_position_name hr_all_positions_f.name%type;

165: p_role_id out nocopy number) is
166: l_member_cd pqh_transaction_categories.member_cd%type;
167: l_position_id number;
168: l_person_name varchar2(240);
169: l_position_name hr_all_positions_f.name%type;
170: l_assignment_id number;
171: l_workflow_enable_flag pqh_transaction_categories.workflow_enable_flag%type;
172: l_proc varchar2(256) := g_package||'get_default_role';
173: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

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