APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_EARNING_RULES

Line 453: from hxt_earning_rules her

449: ) is
450: --
451: CURSOR c_eprules_bg_check is
452: select distinct(pet.business_group_id) bg
453: from hxt_earning_rules her
454: , pay_element_types_f pet
455: where her.egp_id = p_epr_id
456: and her.element_type_id = pet.element_type_id
457: and pet.business_group_id is not null;

Line 1661: from hxt_earning_rules epr

1657: --
1658: CURSOR c_get_epr_bg(p_id number) is
1659: select distinct
1660: pet.business_group_id bg_id
1661: from hxt_earning_rules epr
1662: , pay_element_types_f pet
1663: where epr.egp_id = p_id
1664: and epr.element_type_id = pet.element_type_id
1665: and pet.business_group_id is not null;

Line 1783: from hxt_earning_rules

1779: , hours
1780: , effective_start_date
1781: , days
1782: , effective_end_date
1783: from hxt_earning_rules
1784: where egp_id = p_ep_id;
1785: --
1786: Begin
1787: --

Line 1852: Insert into hxt_earning_rules

1848: open c_seqno;
1849: fetch c_seqno into l_er_id;
1850: close c_seqno;
1851: --
1852: Insert into hxt_earning_rules
1853: ( id
1854: , element_type_id
1855: , egp_id
1856: , seq_no

Line 1903: delete from hxt_earning_rules

1899: end loop;
1900: --
1901: hxt_bg_message_insert('U','Duplicating Earning Policy '||l_name||' Across All Business Groups');
1902: --
1903: delete from hxt_earning_rules
1904: where egp_id = p_ep_id;
1905: --
1906: delete from hxt_earning_policies
1907: where id = p_ep_id;