312: where epr.pep_id = p_pep_id
313: and epr.elt_base_id = pet.element_type_id
314: union
315: select distinct(pet.business_group_id) bg
316: from hxt_prem_eligblty_rules elr
317: , pay_element_types_f pet
318: where elr.pep_id = p_pep_id
319: and elr.elt_base_id = pet.element_type_id
320: union
318: where elr.pep_id = p_pep_id
319: and elr.elt_base_id = pet.element_type_id
320: union
321: select distinct(pet.business_group_id) bg
322: from hxt_prem_eligblty_rules elr
323: , pay_element_types_f pet
324: where elr.pep_id = p_pep_id
325: and elr.elt_premium_id = pet.element_type_id;
326: --
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
1613: and ((elr.elt_base_id = pet.element_type_id