DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PER_VACANCIES

Line 48: 70.10 07-JUL-93 SZWILLIA Moved delete of PER_VACANCIES which

44: and input values.
45: 70.7 01-JUN-93 JTHURING Removed references to
46: ssp_maternity_pay_periods and
47: ssp_periods_of_incapacity
48: 70.10 07-JUL-93 SZWILLIA Moved delete of PER_VACANCIES which
49: was in conflict with assignments.
50: Now in delete_per_misc. Also, moved
51: PER_REQUISITIONS.
52: 70.10 07-JUL-93 mwcallag Delete all database items for a given

Line 1063: DELETE FROM per_vacancies vac

1059: open csr_get_req (p_business_group_id);
1060: fetch csr_get_req into l_exists;
1061: if csr_get_req%found then
1062: --
1063: DELETE FROM per_vacancies vac
1064: WHERE vac.business_group_id = p_business_group_id;
1065: hr_utility.set_location(l_proc,310);
1066: --
1067: DELETE FROM per_requisitions pr