APPS.HR_DELETE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 699: FROM per_assignment_status_types

695: is
696: SELECT null
697: FROM sys.dual
698: WHERE exists(select null
699: FROM per_assignment_status_types
700: WHERE business_group_id = c_business_group_id);
701: --
702: cursor csr_get_ltp
703: (c_business_group_id per_letter_types.business_group_id%TYPE)

Line 1029: DELETE per_assignment_status_types

1025: DELETE PER_ASS_STATUS_TYPE_AMENDS
1026: WHERE business_group_id = p_business_group_id;
1027: hr_utility.set_location(l_proc,150);
1028: --
1029: DELETE per_assignment_status_types
1030: WHERE business_group_id = p_business_group_id;
1031: hr_utility.set_location(l_proc,160);
1032: --
1033: end if;