APPS.HR_UTIL_MISC_SS dependencies on HR_WORKING_PERSON_LISTS

Line 900: FROM hr_working_person_lists

896: --COMMIT;
897: DELETE PER_INTERIM_PERSON_LIST;
898: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
899: SELECT selected_person_id, selected_assignment_id, 'Y'
900: FROM hr_working_person_lists
901: WHERE owning_person_id = person_id;
902: hr_utility.set_location('Leaving: '|| l_proc,10);
903: EXCEPTION
904: WHEN others THEN

Line 917: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,

913: --local variable
914: l_proc constant varchar2(100) := g_package || ' addToMyListFromInterimList';
915: BEGIN
916: hr_utility.set_location('Entering: '|| l_proc,5);
917: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,
918: selected_person_id, current_selection, multiple_selection, selected_assignment_id)
919: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,
920: prsn_id,
921: list.person_id,

Line 919: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,

915: BEGIN
916: hr_utility.set_location('Entering: '|| l_proc,5);
917: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,
918: selected_person_id, current_selection, multiple_selection, selected_assignment_id)
919: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,
920: prsn_id,
921: list.person_id,
922: NULL,
923: NULL,