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_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_PREM_ELIGBLTY_RULES

Line 316: from hxt_prem_eligblty_rules elr

312: where epr.pep_id = p_pep_id
313: and epr.elt_base_id = pet.element_type_id
314: union
315: select distinct(pet.business_group_id) bg
316: from hxt_prem_eligblty_rules elr
317: , pay_element_types_f pet
318: where elr.pep_id = p_pep_id
319: and elr.elt_base_id = pet.element_type_id
320: union

Line 322: from hxt_prem_eligblty_rules elr

318: where elr.pep_id = p_pep_id
319: and elr.elt_base_id = pet.element_type_id
320: union
321: select distinct(pet.business_group_id) bg
322: from hxt_prem_eligblty_rules elr
323: , pay_element_types_f pet
324: where elr.pep_id = p_pep_id
325: and elr.elt_premium_id = pet.element_type_id;
326: --

Line 1609: , hxt_prem_eligblty_rules elr

1605: union
1606: select distinct
1607: pet.business_group_id bg_id
1608: from hxt_prem_eligblty_policies pep
1609: , hxt_prem_eligblty_rules elr
1610: , pay_element_types_f pet
1611: where pep.id = p_id
1612: and pep.id = elr.pep_id
1613: and ((elr.elt_base_id = pet.element_type_id