APPS.HR_DELETE dependencies on PER_SPECIAL_INFO_TYPES

Line 1581: FROM per_special_info_types sit

1577: cursor csr_get_spec_inf_type
1578: (c_business_group_id ff_formulas_f.business_group_id%TYPE)
1579: is
1580: SELECT null
1581: FROM per_special_info_types sit
1582: WHERE business_group_id = c_business_group_id;
1583: --
1584: begin
1585: --

Line 1609: FROM per_special_info_types sit

1605: --
1606: DELETE FROM per_special_info_type_usages situ
1607: WHERE situ.special_information_type_id =
1608: (SELECT sit.special_information_type_id
1609: FROM per_special_info_types sit
1610: WHERE sit.special_information_type_id = situ.special_information_type_id
1611: AND sit.business_group_id = p_business_group_id);
1612: hr_utility.set_location(l_proc,100);
1613: --

Line 1614: DELETE FROM per_special_info_types sit

1610: WHERE sit.special_information_type_id = situ.special_information_type_id
1611: AND sit.business_group_id = p_business_group_id);
1612: hr_utility.set_location(l_proc,100);
1613: --
1614: DELETE FROM per_special_info_types sit
1615: WHERE sit.business_group_id = p_business_group_id;
1616: hr_utility.set_location(l_proc,110);
1617: --
1618: end if;