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 3554: posv.date_from AND NVL(posv.date_to, hr_general.end_of_time);

3550: SELECT posv.org_structure_version_id
3551: FROM per_org_structure_versions posv
3552: WHERE posv.organization_structure_id = p_organization_structure_id
3553: AND p_effective_date BETWEEN
3554: posv.date_from AND NVL(posv.date_to, hr_general.end_of_time);
3555:
3556: BEGIN
3557:
3558: IF g_dbg THEN op('Entering: '||l_proc, 1); END IF;

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

3600: SELECT ppsv.pos_structure_version_id
3601: FROM per_pos_structure_versions ppsv
3602: WHERE ppsv.position_structure_id = p_position_structure_id
3603: AND p_effective_date BETWEEN
3604: ppsv.date_from AND NVL(ppsv.date_to, hr_general.end_of_time);
3605:
3606: BEGIN
3607:
3608: IF g_dbg THEN op('Entering: '||l_proc, 1); END IF;

Line 4939: IF hr_general2.get_oracle_db_version >= 9 THEN

4935: --
4936: -- Oracle 8/8i does not support BULK COLLECT of a dynamic PL/SQL
4937: -- statement.
4938: --
4939: IF hr_general2.get_oracle_db_version >= 9 THEN
4940: --
4941: -- Oracle 9+ being used so perform a BULK COLLECT.
4942: --
4943: FETCH l_csr BULK COLLECT INTO l_temp_asg_tbl

Line 5374: IF hr_general2.get_oracle_db_version >= 9 THEN

5370: --
5371: -- Oracle 8/8i does not support BULK COLLECT of a dynamic PL/SQL
5372: -- statement.
5373: --
5374: IF hr_general2.get_oracle_db_version >= 9 THEN
5375: --
5376: -- Oracle 9+ being used so perform a BULK COLLECT.
5377: --
5378: FETCH l_csr BULK COLLECT INTO l_temp_asg_tbl