APPS.HR_UTIL_MISC_SS dependencies on HR_WORKING_PERSON_LISTS

Line 1104: FROM hr_working_person_lists

1100: --COMMIT;
1101: DELETE PER_INTERIM_PERSON_LIST;
1102: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1103: SELECT selected_person_id, selected_assignment_id, 'Y'
1104: FROM hr_working_person_lists
1105: WHERE owning_person_id = person_id;
1106: hr_utility.set_location('Leaving: '|| l_proc,10);
1107: EXCEPTION
1108: WHEN others THEN

Line 1121: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,

1117: --local variable
1118: l_proc constant varchar2(100) := g_package || ' addToMyListFromInterimList';
1119: BEGIN
1120: hr_utility.set_location('Entering: '|| l_proc,5);
1121: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,
1122: selected_person_id, current_selection, multiple_selection, selected_assignment_id)
1123: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,
1124: prsn_id,
1125: list.person_id,

Line 1123: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,

1119: BEGIN
1120: hr_utility.set_location('Entering: '|| l_proc,5);
1121: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,
1122: selected_person_id, current_selection, multiple_selection, selected_assignment_id)
1123: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,
1124: prsn_id,
1125: list.person_id,
1126: NULL,
1127: NULL,