DBA Data[Home] [Help]

APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_PREM_INTERACT_POL_RULES

Line 371: from hxt_prem_interact_pol_rules ipr

367: where itr.pip_id = p_pip_id
368: and itr.elt_earned_prem_id = pet.element_type_id
369: union
370: select distinct(pet.business_group_id) bg
371: from hxt_prem_interact_pol_rules ipr
372: , pay_element_types_f pet
373: where ipr.pip_id = p_pip_id
374: and ipr.elt_earned_prem_id = pet.element_type_id;
375: --

Line 1634: , hxt_prem_interact_pol_rules ipr

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
1638: and ipr.elt_earned_prem_id = pet.element_type_id