APPS.HR_DELETE dependencies on PER_PARENT_SPINES

Line 712: (c_business_group_id per_parent_spines.business_group_id%TYPE)

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)
713: is
714: SELECT null
715: FROM sys.dual
716: WHERE exists(select null

Line 717: FROM per_parent_spines

713: is
714: SELECT null
715: FROM sys.dual
716: WHERE exists(select null
717: FROM per_parent_spines
718: WHERE business_group_id = c_business_group_id);
719: --
720: cursor csr_get_gra
721: (c_business_group_id per_grades.business_group_id%TYPE)

Line 1097: (c_business_group_id per_parent_spines.business_group_id%TYPE)

1093: FROM per_grades
1094: WHERE business_group_id = c_business_group_id;
1095: --
1096: cursor csr_get_prs
1097: (c_business_group_id per_parent_spines.business_group_id%TYPE)
1098: is
1099: SELECT null
1100: FROM per_parent_spines
1101: WHERE business_group_id = c_business_group_id;

Line 1100: FROM per_parent_spines

1096: cursor csr_get_prs
1097: (c_business_group_id per_parent_spines.business_group_id%TYPE)
1098: is
1099: SELECT null
1100: FROM per_parent_spines
1101: WHERE business_group_id = c_business_group_id;
1102: --
1103: begin
1104: hr_utility.set_location('Entering: '||l_proc,10);

Line 1150: DELETE FROM per_parent_spines

1146: DELETE FROM per_spinal_points
1147: WHERE business_group_id = p_business_group_id;
1148: hr_utility.set_location(l_proc,190);
1149: --
1150: DELETE FROM per_parent_spines
1151: WHERE business_group_id = p_business_group_id;
1152: hr_utility.set_location(l_proc,200);
1153: --
1154: end if;