APPS.HR_RUNGEN dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 251: INSERT INTO hr_assignment_set_amendments

247: end if;
248: --
249: -- Now add this assignment to the appropreate set.
250: --
251: INSERT INTO hr_assignment_set_amendments
252: (ASSIGNMENT_ID
253: ,ASSIGNMENT_SET_ID
254: ,INCLUDE_OR_EXCLUDE
255: )

Line 350: INSERT INTO hr_assignment_set_amendments

346: end if;
347: --
348: -- Now add this assignment to the appropreate set.
349: --
350: INSERT INTO hr_assignment_set_amendments
351: (ASSIGNMENT_ID
352: ,ASSIGNMENT_SET_ID
353: ,INCLUDE_OR_EXCLUDE
354: )

Line 571: delete from hr_assignment_set_amendments

567: l_num_sepchecks := g_sepcheck_asg_sets.sz;
568: --
569: for l_sc_counter in 1..l_num_sepchecks loop
570: --
571: delete from hr_assignment_set_amendments
572: where ASSIGNMENT_SET_ID = g_sepcheck_asg_sets.set_id(l_sc_counter);
573: --
574: delete from hr_assignment_sets
575: where ASSIGNMENT_SET_ID = g_sepcheck_asg_sets.set_id(l_sc_counter);

Line 590: delete from hr_assignment_set_amendments

586: l_num_taxsep := g_taxsep_asg_sets.sz;
587: --
588: for l_ts_counter in 1..l_num_taxsep loop
589: --
590: delete from hr_assignment_set_amendments
591: where ASSIGNMENT_SET_ID = g_taxsep_asg_sets.set_id(l_ts_counter);
592: --
593: delete from hr_assignment_sets
594: where ASSIGNMENT_SET_ID = g_taxsep_asg_sets.set_id(l_ts_counter);

Line 1136: DELETE FROM hr_assignment_set_amendments

1132: WHERE assignment_set_id = p_assignment_set_id;
1133: */
1134: --
1135: hr_utility.set_location('hr_rungen.Del_Asg_Amends', 11);
1136: DELETE FROM hr_assignment_set_amendments
1137: WHERE assignment_set_id = p_assignment_set_id;
1138: --
1139: EXCEPTION WHEN NO_DATA_FOUND THEN
1140: NULL;