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_ASG_WRAPPER dependencies on HR_GENERAL

Line 552: and NVL(posvv.date_to,hr_general.end_of_time)

548: per_org_structure_versions_v posvv,
549: fnd_sessions fs
550: Where posvv.organization_structure_id = posv.organization_structure_id
551: and fs.effective_date Between posvv.date_from
552: and NVL(posvv.date_to,hr_general.end_of_time)
553: And posv.organization_structure_id = p_organization_structure_id
554: And fs.session_id = userenv('sessionid');
555: --
556: -- Bug fix 3648688.

Line 643: and hr_general.effective_date between osv.date_from

639: select organization_id_parent
640: from per_org_structure_elements ose,
641: per_org_structure_versions osv
642: where osv.organization_structure_id = p_org_hierarchy_id
643: and hr_general.effective_date between osv.date_from
644: and nvl(osv.date_to,hr_general.end_of_time)
645: and osv.org_structure_version_id = ose.org_structure_version_id
646: and not exists
647: (select 'X'

Line 644: and nvl(osv.date_to,hr_general.end_of_time)

640: from per_org_structure_elements ose,
641: per_org_structure_versions osv
642: where osv.organization_structure_id = p_org_hierarchy_id
643: and hr_general.effective_date between osv.date_from
644: and nvl(osv.date_to,hr_general.end_of_time)
645: and osv.org_structure_version_id = ose.org_structure_version_id
646: and not exists
647: (select 'X'
648: from per_org_structure_elements ose2

Line 748: AND hr_general.effective_date BETWEEN v.date_from

744: AND o.org_structure_version_id =
745: (SELECT v.org_structure_version_id
746: FROM per_org_structure_versions v
747: WHERE v.organization_structure_id = g_org_hierarchy_id
748: AND hr_general.effective_date BETWEEN v.date_from
749: AND NVL(v.date_to, hr_general.end_of_time)));
750: if l_dummy = 'X' then
751: hr_utility.set_location(l_proc,52);
752: v_org_in_hierarchy := TRUE;

Line 749: AND NVL(v.date_to, hr_general.end_of_time)));

745: (SELECT v.org_structure_version_id
746: FROM per_org_structure_versions v
747: WHERE v.organization_structure_id = g_org_hierarchy_id
748: AND hr_general.effective_date BETWEEN v.date_from
749: AND NVL(v.date_to, hr_general.end_of_time)));
750: if l_dummy = 'X' then
751: hr_utility.set_location(l_proc,52);
752: v_org_in_hierarchy := TRUE;
753: end if;

Line 808: AND hr_general.effective_date BETWEEN v.date_from

804: AND o.org_structure_version_id =
805: (SELECT v.org_structure_version_id
806: FROM per_org_structure_versions v
807: WHERE v.organization_structure_id = g_org_hierarchy_id
808: AND hr_general.effective_date BETWEEN v.date_from
809: AND NVL(v.date_to, hr_general.end_of_time)));
810: if l_dummy = 'X' then
811: v_org_in_hierarchy := TRUE;
812: end if;

Line 809: AND NVL(v.date_to, hr_general.end_of_time)));

805: (SELECT v.org_structure_version_id
806: FROM per_org_structure_versions v
807: WHERE v.organization_structure_id = g_org_hierarchy_id
808: AND hr_general.effective_date BETWEEN v.date_from
809: AND NVL(v.date_to, hr_general.end_of_time)));
810: if l_dummy = 'X' then
811: v_org_in_hierarchy := TRUE;
812: end if;
813: exception

Line 938: and hr_general.effective_date between osv.date_from

934: select parent_position_id
935: from per_pos_structure_elements ose,
936: per_pos_structure_versions osv
937: where osv.position_structure_id = p_pos_hierarchy_id
938: and hr_general.effective_date between osv.date_from
939: and nvl(osv.date_to,hr_general.end_of_time)
940: and osv.pos_structure_version_id = ose.pos_structure_version_id
941: and not exists
942: (select 'X'

Line 939: and nvl(osv.date_to,hr_general.end_of_time)

935: from per_pos_structure_elements ose,
936: per_pos_structure_versions osv
937: where osv.position_structure_id = p_pos_hierarchy_id
938: and hr_general.effective_date between osv.date_from
939: and nvl(osv.date_to,hr_general.end_of_time)
940: and osv.pos_structure_version_id = ose.pos_structure_version_id
941: and not exists
942: (select 'X'
943: from per_pos_structure_elements ose2

Line 1047: AND hr_general.effective_date BETWEEN v.date_from

1043: AND o.pos_structure_version_id =
1044: (SELECT v.pos_structure_version_id
1045: FROM per_pos_structure_versions v
1046: WHERE v.position_structure_id = g_pos_hierarchy_id
1047: AND hr_general.effective_date BETWEEN v.date_from
1048: AND NVL(v.date_to, hr_general.end_of_time)));
1049: if l_dummy = 'X' then
1050: hr_utility.set_location(l_proc,50);
1051: v_pos_in_hierarchy := TRUE;

Line 1048: AND NVL(v.date_to, hr_general.end_of_time)));

1044: (SELECT v.pos_structure_version_id
1045: FROM per_pos_structure_versions v
1046: WHERE v.position_structure_id = g_pos_hierarchy_id
1047: AND hr_general.effective_date BETWEEN v.date_from
1048: AND NVL(v.date_to, hr_general.end_of_time)));
1049: if l_dummy = 'X' then
1050: hr_utility.set_location(l_proc,50);
1051: v_pos_in_hierarchy := TRUE;
1052: end if;

Line 1106: AND hr_general.effective_date BETWEEN v.date_from

1102: AND o.pos_structure_version_id =
1103: (SELECT v.pos_structure_version_id
1104: FROM per_pos_structure_versions v
1105: WHERE v.position_structure_id = g_pos_hierarchy_id
1106: AND hr_general.effective_date BETWEEN v.date_from
1107: AND NVL(v.date_to, hr_general.end_of_time)));
1108: if l_dummy = 'X' then
1109: hr_utility.set_location(l_proc,100);
1110: v_pos_in_hierarchy := TRUE;

Line 1107: AND NVL(v.date_to, hr_general.end_of_time)));

1103: (SELECT v.pos_structure_version_id
1104: FROM per_pos_structure_versions v
1105: WHERE v.position_structure_id = g_pos_hierarchy_id
1106: AND hr_general.effective_date BETWEEN v.date_from
1107: AND NVL(v.date_to, hr_general.end_of_time)));
1108: if l_dummy = 'X' then
1109: hr_utility.set_location(l_proc,100);
1110: v_pos_in_hierarchy := TRUE;
1111: end if;