APPS.HXT_CHK_BG_AND_UPGRADE_PKG dependencies on HXT_HOLIDAY_CALENDARS

Line 78: FROM hxt_holiday_calendars hcl;

74: CURSOR c_get_hol_cals IS
75: SELECT DISTINCT
76: hcl.id
77: , hcl.name
78: FROM hxt_holiday_calendars hcl;
79: --
80: -- cursor to get all Earning Policies
81: --
82: CURSOR c_get_earn_pols IS

Line 408: from hxt_holiday_calendars hcl

404: ) is
405: --
406: CURSOR c_hcl_bg_check is
407: select distinct(pet.business_group_id) bg
408: from hxt_holiday_calendars hcl
409: , pay_element_types_f pet
410: where hcl.id = p_hcl_id
411: and hcl.element_type_id = pet.element_type_id
412: and pet.business_group_id is not null

Line 415: from hxt_holiday_calendars hcl

411: and hcl.element_type_id = pet.element_type_id
412: and pet.business_group_id is not null
413: union
414: select distinct(hou.business_group_id) bg
415: from hxt_holiday_calendars hcl
416: , hr_organization_units hou
417: where hcl.id = p_hcl_id
418: and hcl.organization_id = hou.organization_id
419: and hou.business_group_id is not null;

Line 1644: from hxt_holiday_calendars hcl

1640: --
1641: CURSOR c_get_hcl_bg(p_id number) is
1642: select distinct
1643: pet.business_group_id bg_id
1644: from hxt_holiday_calendars hcl
1645: , pay_element_types_f pet
1646: where hcl.id = p_id
1647: and hcl.element_type_id = pet.element_type_id
1648: and pet.business_group_id is not null

Line 1652: from hxt_holiday_calendars hcl

1648: and pet.business_group_id is not null
1649: union
1650: select distinct
1651: hou.business_group_id bg_id
1652: from hxt_holiday_calendars hcl
1653: , hr_organization_units hou
1654: where hcl.id = p_id
1655: and hcl.organization_id = hou.organization_id
1656: and hou.business_group_id is not null;