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

Line 473: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))

469: AND hav.alias_definition_id = p_alias_definition_id
470: and havt.language = USERENV('LANG')
471: AND hav.alias_value_id <> nvl(p_alias_value_id,9.99E125)
472: AND ((p_date_from BETWEEN hav.date_from
473: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
474: OR
475: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
476: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
477: OR

Line 475: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN

471: AND hav.alias_value_id <> nvl(p_alias_value_id,9.99E125)
472: AND ((p_date_from BETWEEN hav.date_from
473: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
474: OR
475: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
476: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
477: OR
478: (hav.date_from BETWEEN p_date_from
479: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))

Line 476: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))

472: AND ((p_date_from BETWEEN hav.date_from
473: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
474: OR
475: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
476: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
477: OR
478: (hav.date_from BETWEEN p_date_from
479: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
480: OR

Line 479: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))

475: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
476: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
477: OR
478: (hav.date_from BETWEEN p_date_from
479: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
480: OR
481: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
482: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)));
483: --

Line 481: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN

477: OR
478: (hav.date_from BETWEEN p_date_from
479: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
480: OR
481: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
482: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)));
483: --
484: l_dup_name varchar2(5) := NULL;
485: --

Line 482: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)));

478: (hav.date_from BETWEEN p_date_from
479: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
480: OR
481: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
482: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)));
483: --
484: l_dup_name varchar2(5) := NULL;
485: --
486: BEGIN

Line 626: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))

622: FROM hxc_alias_values hav
623: WHERE hav.alias_definition_id = p_alias_definition_id
624: AND hav.object_version_number <> NVL(p_ovn, -1)
625: AND ((p_date_from BETWEEN hav.date_from
626: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
627: OR
628: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
629: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
630: OR

Line 628: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN

624: AND hav.object_version_number <> NVL(p_ovn, -1)
625: AND ((p_date_from BETWEEN hav.date_from
626: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
627: OR
628: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
629: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
630: OR
631: (hav.date_from BETWEEN p_date_from
632: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))

Line 629: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))

625: AND ((p_date_from BETWEEN hav.date_from
626: AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
627: OR
628: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
629: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
630: OR
631: (hav.date_from BETWEEN p_date_from
632: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
633: OR

Line 632: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))

628: (NVL(p_date_to, HR_GENERAL.END_OF_TIME) BETWEEN
629: hav.date_from AND NVL(hav.date_to, HR_GENERAL.END_OF_TIME))
630: OR
631: (hav.date_from BETWEEN p_date_from
632: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
633: OR
634: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
635: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)))
636: AND hav.alias_value_id <> nvl(p_alias_value_id,9.99E125)

Line 634: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN

630: OR
631: (hav.date_from BETWEEN p_date_from
632: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
633: OR
634: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
635: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)))
636: AND hav.alias_value_id <> nvl(p_alias_value_id,9.99E125)
637: AND hav.attribute_category = p_attribute_category
638: AND nvl(hav.attribute1,chr(0)) = nvl(p_attribute1,chr(0))

Line 635: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)))

631: (hav.date_from BETWEEN p_date_from
632: AND NVL(p_date_to, HR_GENERAL.END_OF_TIME))
633: OR
634: (NVL(hav.date_to, HR_GENERAL.END_OF_TIME) BETWEEN
635: p_date_from AND NVL(p_date_to, HR_GENERAL.END_OF_TIME)))
636: AND hav.alias_value_id <> nvl(p_alias_value_id,9.99E125)
637: AND hav.attribute_category = p_attribute_category
638: AND nvl(hav.attribute1,chr(0)) = nvl(p_attribute1,chr(0))
639: AND nvl(hav.attribute2,chr(0)) = nvl(p_attribute2,chr(0))