DBA Data[Home] [Help]

APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_PREM_ELIGBLTY_POL_RULES

Line 310: from hxt_prem_eligblty_pol_rules epr

306: ) is
307: --
308: CURSOR c_pep_bg_check is
309: select distinct(pet.business_group_id) bg
310: from hxt_prem_eligblty_pol_rules epr
311: , pay_element_types_f pet
312: where epr.pep_id = p_pep_id
313: and epr.elt_base_id = pet.element_type_id
314: union

Line 1599: , hxt_prem_eligblty_pol_rules epr

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
1603: and epr.elt_base_id = pet.element_type_id