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_PTX_UTL dependencies on HR_POSITIONS

Line 135: v_posn_rec HR_POSITIONS%ROWTYPE;

131: p_action_date in date,
132: p_review_flag in pqh_position_transactions.review_flag%type
133: ) is
134: l_object_version_number number := 1;
135: v_posn_rec HR_POSITIONS%ROWTYPE;
136: l_pei_populated varchar2(5000);
137: l_jtr_populated varchar2(5000);
138: l_ptx_deployment_factor_id number;
139: --

Line 146: FROM hr_positions

142: from dual;
143: --
144: CURSOR c1 IS
145: SELECT *
146: FROM hr_positions
147: WHERE position_id = p_position_id;
148: v_wc_rec PER_DEPLOYMENT_FACTORS%ROWTYPE;
149: --
150: CURSOR c2 IS

Line 398: select * from hr_positions

394: /*
395: PROCEDURE create_shadow_record(p_position_transaction_id number,p_position_id number) IS
396:
397: cursor c1 is
398: select * from hr_positions
399: where position_id=p_position_id;
400:
401: cursor c2 is
402: select *