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_POLICIES

Line 62: FROM hxt_prem_eligblty_policies pep;

58: CURSOR c_get_peps IS
59: SELECT DISTINCT
60: pep.id
61: , pep.name
62: FROM hxt_prem_eligblty_policies pep;
63: --
64: -- cursor to get all Premium Interaction Policies.
65: --
66: CURSOR c_get_pips IS

Line 1598: from hxt_prem_eligblty_policies pep

1594: --
1595: CURSOR c_get_pep_bg(p_id number) is
1596: select distinct
1597: pet.business_group_id bg_id
1598: from hxt_prem_eligblty_policies pep
1599: , hxt_prem_eligblty_pol_rules epr
1600: , pay_element_types_f pet
1601: where pep.id = p_id
1602: and pep.id = epr.pep_id

Line 1608: from hxt_prem_eligblty_policies pep

1604: and pet.business_group_id is not null
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