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
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
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