APPS.HR_DELETE dependencies on PER_LETTER_TYPES

Line 703: (c_business_group_id per_letter_types.business_group_id%TYPE)

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)
704: is
705: SELECT null
706: FROM sys.dual
707: WHERE exists(select null

Line 708: FROM per_letter_types

704: is
705: SELECT null
706: FROM sys.dual
707: WHERE exists(select null
708: FROM per_letter_types
709: WHERE business_group_id = c_business_group_id);
710: --
711: cursor csr_get_prs
712: (c_business_group_id per_parent_spines.business_group_id%TYPE)

Line 834: DELETE per_letter_types

830: DELETE per_letter_gen_statuses
831: WHERE business_group_id = p_business_group_id;
832: hr_utility.set_location(l_proc,40);
833: --
834: DELETE per_letter_types
835: WHERE business_group_id = p_business_group_id;
836: hr_utility.set_location(l_proc,50);
837: --
838: end if;