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.PER_POS_STRUCTURE_ELEMENTS_PKG dependencies on DUAL

Line 230: from sys.dual

226: l_exists VARCHAR2(1);
227: begin
228: select null
229: into l_exists
230: from sys.dual
231: where X_Position_Id in
232: (select a.subordinate_position_id
233: from per_POS_structure_elements a
234: where a.business_group_id + 0 = X_Business_Group_Id

Line 336: from sys.dual

332: begin
333: begin
334: select null
335: into l_dummy
336: from sys.dual
337: where exists(select 1
338: from per_pos_structure_elements pse
339: where pse.parent_position_id = X_Subordinate_position_Id
340: and pse.pos_structure_version_id = X_Pos_Structure_version_Id);

Line 353: from sys.dual

349: if X_Hr_Installed <> 'I' then
350: begin
351: select null
352: into l_dummy
353: from sys.dual
354: where exists(select 1
355: from per_security_profiles psp
356: where psp.business_group_id + 0 = X_Business_Group_Id
357: and psp.position_id = X_Subordinate_position_Id

Line 379: CURSOR C2 IS SELECT per_pos_structure_elements_s.nextval FROM sys.dual;

375: X_Parent_Position_Id NUMBER
376: ) IS
377: CURSOR C IS SELECT rowid FROM PER_POS_STRUCTURE_ELEMENTS
378: WHERE pos_structure_element_id = X_Pos_Structure_Element_Id;
379: CURSOR C2 IS SELECT per_pos_structure_elements_s.nextval FROM sys.dual;
380: --
381: cursor get_details is select rowid, POS_STRUCTURE_ELEMENT_ID
382: ,BUSINESS_GROUP_ID, POS_STRUCTURE_VERSION_ID
383: ,SUBORDINATE_POSITION_ID,PARENT_POSITION_ID