DBA Data[Home] [Help]

APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_EARN_GROUPS

Line 272: from hxt_earn_groups egr

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;

Line 1587: from hxt_earn_groups egr

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