268: ) is
269: --
270: CURSOR c_eg_bg_check is
271: select distinct(pet.business_group_id) bg
272: from hxt_earn_groups egr
273: , pay_element_types_f pet
274: where egr.egt_id = p_eg_id
275: and egr.element_type_id = pet.element_type_id
276: and pet.business_group_id is not null;
1583: --
1584: CURSOR c_get_egt_bg(p_id number) is
1585: select distinct
1586: pet.business_group_id bg_id
1587: from hxt_earn_groups egr
1588: , hxt_earn_group_types egt
1589: , pay_element_types_f pet
1590: where egt.id = p_id
1591: and egt.id = egr.egt_id