APPS.HR_DELETE dependencies on PER_ORGANIZATION_STRUCTURES

Line 1972: PER_ORGANIZATION_STRUCTURES.business_group_id%TYPE)

1968: l_security_group_id per_business_groups.security_group_id%TYPE;
1969: --
1970: cursor csr_get_ost
1971: (c_business_group_id
1972: PER_ORGANIZATION_STRUCTURES.business_group_id%TYPE)
1973: is
1974: SELECT null
1975: FROM PER_ORGANIZATION_STRUCTURES
1976: WHERE business_group_id = c_business_group_id;

Line 1975: FROM PER_ORGANIZATION_STRUCTURES

1971: (c_business_group_id
1972: PER_ORGANIZATION_STRUCTURES.business_group_id%TYPE)
1973: is
1974: SELECT null
1975: FROM PER_ORGANIZATION_STRUCTURES
1976: WHERE business_group_id = c_business_group_id;
1977: --
1978: cursor deltype (p_sec_grp in number) is
1979: select lookup_type

Line 2086: DELETE per_organization_structures

2082: DELETE per_org_structure_versions
2083: WHERE business_group_id = p_business_group_id;
2084: hr_utility.set_location(l_proc, 40);
2085: --
2086: DELETE per_organization_structures
2087: WHERE business_group_id = p_business_group_id;
2088: hr_utility.set_location(l_proc, 50);
2089: --
2090: end if;