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.

[Home] [Help]

APPS.HR_CAL_ENTRY_VALUE_API dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 643: select ORG_STRUCTURE_ELEMENT_ID from PER_ORG_STRUCTURE_ELEMENTS

639: --
640: -- also returns . delimited list of the link's parent link ids
641: --
642: CURSOR csr_get_level IS
643: select ORG_STRUCTURE_ELEMENT_ID from PER_ORG_STRUCTURE_ELEMENTS
644: where ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
645: connect by ORGANIZATION_ID_CHILD = prior ORGANIZATION_ID_PARENT
646: AND ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
647: start with ORG_STRUCTURE_ELEMENT_ID = P_ORG_STRUCTURE_ELEMENT_ID;