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.HR_SECURITY_INTERNAL dependencies on HR_GENERAL

Line 3594: posv.date_from AND NVL(posv.date_to, hr_general.end_of_time);

3590: SELECT posv.org_structure_version_id
3591: FROM per_org_structure_versions posv
3592: WHERE posv.organization_structure_id = p_organization_structure_id
3593: AND p_effective_date BETWEEN
3594: posv.date_from AND NVL(posv.date_to, hr_general.end_of_time);
3595:
3596: BEGIN
3597:
3598: IF g_dbg THEN op('Entering: '||l_proc, 1); END IF;

Line 3644: ppsv.date_from AND NVL(ppsv.date_to, hr_general.end_of_time);

3640: SELECT ppsv.pos_structure_version_id
3641: FROM per_pos_structure_versions ppsv
3642: WHERE ppsv.position_structure_id = p_position_structure_id
3643: AND p_effective_date BETWEEN
3644: ppsv.date_from AND NVL(ppsv.date_to, hr_general.end_of_time);
3645:
3646: BEGIN
3647:
3648: IF g_dbg THEN op('Entering: '||l_proc, 1); END IF;

Line 5073: IF hr_general2.get_oracle_db_version >= 9 THEN

5069: --
5070: -- Oracle 8/8i does not support BULK COLLECT of a dynamic PL/SQL
5071: -- statement.
5072: --
5073: IF hr_general2.get_oracle_db_version >= 9 THEN
5074: --
5075: -- Oracle 9+ being used so perform a BULK COLLECT.
5076: --
5077: FETCH l_csr BULK COLLECT INTO l_temp_asg_tbl

Line 5570: IF hr_general2.get_oracle_db_version >= 9 THEN

5566: --
5567: -- Oracle 8/8i does not support BULK COLLECT of a dynamic PL/SQL
5568: -- statement.
5569: --
5570: IF hr_general2.get_oracle_db_version >= 9 THEN
5571: --
5572: -- Oracle 9+ being used so perform a BULK COLLECT.
5573: --
5574: FETCH l_csr BULK COLLECT INTO l_temp_asg_tbl