APPS.HR_DELETE dependencies on PER_GRADES

Line 721: (c_business_group_id per_grades.business_group_id%TYPE)

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)
722: is
723: SELECT null
724: FROM sys.dual
725: WHERE exists(select null

Line 726: FROM per_grades

722: is
723: SELECT null
724: FROM sys.dual
725: WHERE exists(select null
726: FROM per_grades
727: WHERE business_group_id = c_business_group_id);
728: --
729: cursor csr_get_job
730: (c_business_group_id per_jobs.business_group_id%TYPE)

Line 1090: (c_business_group_id per_grades.business_group_id%TYPE)

1086: --
1087: l_exists varchar2(1);
1088: --
1089: cursor csr_get_gra
1090: (c_business_group_id per_grades.business_group_id%TYPE)
1091: is
1092: SELECT null
1093: FROM per_grades
1094: WHERE business_group_id = c_business_group_id;

Line 1093: FROM per_grades

1089: cursor csr_get_gra
1090: (c_business_group_id per_grades.business_group_id%TYPE)
1091: is
1092: SELECT null
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)

Line 1121: DELETE FROM per_grades_tl gdt

1117: DELETE FROM per_valid_grades vg
1118: WHERE vg.business_group_id = p_business_group_id;
1119: hr_utility.set_location(l_proc,230);
1120: --
1121: DELETE FROM per_grades_tl gdt
1122: WHERE gdt.grade_id IN (SELECT pg.grade_id
1123: FROM per_grades pg
1124: WHERE pg.business_group_id = p_business_group_id);
1125: hr_utility.set_location(l_proc,235);

Line 1123: FROM per_grades pg

1119: hr_utility.set_location(l_proc,230);
1120: --
1121: DELETE FROM per_grades_tl gdt
1122: WHERE gdt.grade_id IN (SELECT pg.grade_id
1123: FROM per_grades pg
1124: WHERE pg.business_group_id = p_business_group_id);
1125: hr_utility.set_location(l_proc,235);
1126: --
1127: DELETE FROM per_grades pg

Line 1127: DELETE FROM per_grades pg

1123: FROM per_grades pg
1124: WHERE pg.business_group_id = p_business_group_id);
1125: hr_utility.set_location(l_proc,235);
1126: --
1127: DELETE FROM per_grades pg
1128: WHERE pg.business_group_id = p_business_group_id;
1129: hr_utility.set_location(l_proc,240);
1130: --
1131: end if;