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.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_EARN_GROUPS

Line 3723: INDEX(eg HXT_EARN_GROUPS_EGT_FK) */

3719:
3720: CURSOR get_earn_group_elements ( p_ep_id IN NUMBER)
3721: IS SELECT /*+ LEADING(ep)
3722: INDEX(ep HXT_EARNING_POLICIES_PK)
3723: INDEX(eg HXT_EARN_GROUPS_EGT_FK) */
3724: element_type_id
3725: FROM hxt_earning_policies ep,
3726: hxt_earn_groups eg
3727: WHERE ep.id = p_ep_id

Line 3726: hxt_earn_groups eg

3722: INDEX(ep HXT_EARNING_POLICIES_PK)
3723: INDEX(eg HXT_EARN_GROUPS_EGT_FK) */
3724: element_type_id
3725: FROM hxt_earning_policies ep,
3726: hxt_earn_groups eg
3727: WHERE ep.id = p_ep_id
3728: AND eg.egt_id = ep.egt_id
3729: ORDER BY element_type_id ;
3730: