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 4511: INDEX(eg HXT_EARN_GROUPS_EGT_FK) */

4507:
4508: CURSOR get_earn_group_elements ( p_ep_id IN NUMBER)
4509: IS SELECT /*+ LEADING(ep)
4510: INDEX(ep HXT_EARNING_POLICIES_PK)
4511: INDEX(eg HXT_EARN_GROUPS_EGT_FK) */
4512: element_type_id
4513: FROM hxt_earning_policies ep,
4514: hxt_earn_groups eg
4515: WHERE ep.id = p_ep_id

Line 4514: hxt_earn_groups eg

4510: INDEX(ep HXT_EARNING_POLICIES_PK)
4511: INDEX(eg HXT_EARN_GROUPS_EGT_FK) */
4512: element_type_id
4513: FROM hxt_earning_policies ep,
4514: hxt_earn_groups eg
4515: WHERE ep.id = p_ep_id
4516: AND eg.egt_id = ep.egt_id
4517: ORDER BY element_type_id ;
4518: