DBA Data[Home] [Help]

APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_SUM_HOURS_WORKED_F

Line 694: from hxt_sum_hours_worked_f shw

690: ) is
691: --
692: CURSOR c_shw_bg_check is
693: select distinct(pet.business_group_id) bg
694: from hxt_sum_hours_worked_f shw
695: , pay_element_types_f pet
696: where shw.tim_id = p_tim_id
697: and shw.element_type_id = pet.element_type_id
698: and pet.business_group_id is not null

Line 701: from hxt_sum_hours_worked_f shw

697: and shw.element_type_id = pet.element_type_id
698: and pet.business_group_id is not null
699: union
700: select distinct(ass.business_group_id) bg
701: from hxt_sum_hours_worked_f shw
702: , per_assignments_f ass
703: where shw.tim_id = p_tim_id
704: and shw.assignment_id = ass.assignment_id;
705: --