APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on DUAL

Line 702: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;

698:
699: OPEN get_list_id_from;
700: FETCH get_list_id_from INTO l_list_id_from;
701: CLOSE get_list_id_from;
702: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
703:
704: -- create new entry into pa_distribution_lists
705:
706: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',

Line 749: select pa_dist_list_items_s.nextVal into l_list_item_id from dual;

745: l_recipient_id := l_project_party_id;
746: END IF;
747:
748:
749: select pa_dist_list_items_s.nextVal into l_list_item_id from dual;
750:
751: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST_ITEM(P_VALIDATE_ONLY => 'F',
752: P_LIST_ITEM_ID => l_list_item_id,
753: P_LIST_ID => l_list_id_to,