APPS.HR_RUNGEN dependencies on HR_ASSIGNMENT_SETS

Line 229: SELECT hr_assignment_sets_s.nextval

225: -- OK we need to insert a new assignment set.
226: --
227: l_set_name := l_master_set_name||l_ts_counter;
228: --
229: SELECT hr_assignment_sets_s.nextval
230: INTO l_ts_asg_set_id
231: FROM sys.dual;
232: --
233: INSERT INTO hr_assignment_sets (

Line 233: INSERT INTO hr_assignment_sets (

229: SELECT hr_assignment_sets_s.nextval
230: INTO l_ts_asg_set_id
231: FROM sys.dual;
232: --
233: INSERT INTO hr_assignment_sets (
234: ASSIGNMENT_SET_ID
235: ,BUSINESS_GROUP_ID
236: ,PAYROLL_ID
237: ,ASSIGNMENT_SET_NAME)

Line 328: SELECT hr_assignment_sets_s.nextval

324: -- OK we need to insert a new assignment set.
325: --
326: l_set_name := l_master_set_name||l_sc_counter;
327: --
328: SELECT hr_assignment_sets_s.nextval
329: INTO l_sc_asg_set_id
330: FROM sys.dual;
331: --
332: INSERT INTO hr_assignment_sets (

Line 332: INSERT INTO hr_assignment_sets (

328: SELECT hr_assignment_sets_s.nextval
329: INTO l_sc_asg_set_id
330: FROM sys.dual;
331: --
332: INSERT INTO hr_assignment_sets (
333: ASSIGNMENT_SET_ID
334: ,BUSINESS_GROUP_ID
335: ,PAYROLL_ID
336: ,ASSIGNMENT_SET_NAME)

Line 574: delete from hr_assignment_sets

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);
576: --
577: end loop;
578: end delete_sepcheck_asg_set;

Line 593: delete from hr_assignment_sets

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);
595: --
596: end loop;
597: end delete_taxsep_asg_set;