DBA Data[Home] [Help]

APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_PREM_INTERACT_POLICIES

Line 70: FROM hxt_prem_interact_policies pip;

66: CURSOR c_get_pips IS
67: SELECT DISTINCT
68: pip.id
69: , pip.name
70: FROM hxt_prem_interact_policies pip;
71: --
72: -- cursor to get all Holiday Calendars.
73: --
74: CURSOR c_get_hol_cals IS

Line 1621: from hxt_prem_interact_policies pip

1617: --
1618: CURSOR c_get_pip_bg(p_id number) is
1619: select distinct
1620: pet.business_group_id bg_id
1621: from hxt_prem_interact_policies pip
1622: , hxt_prem_interact_rules itr
1623: , pay_element_types_f pet
1624: where pip.id = p_id
1625: and pip.id = itr.pip_id

Line 1633: from hxt_prem_interact_policies pip

1629: and pet.business_group_id is not null))
1630: union
1631: select distinct
1632: pet.business_group_id bg_id
1633: from hxt_prem_interact_policies pip
1634: , hxt_prem_interact_pol_rules ipr
1635: , pay_element_types_f pet
1636: where pip.id = p_id
1637: and pip.id = ipr.pip_id