APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on DUAL

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

731:
732: OPEN get_list_id_from;
733: FETCH get_list_id_from INTO l_list_id_from;
734: CLOSE get_list_id_from;
735: select pa_distribution_lists_s.nextVal into l_list_id_to from dual;
736:
737: -- create new entry into pa_distribution_lists
738:
739: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST(P_VALIDATE_ONLY => 'F',

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

806: -- copy project we can avoid creating dist list items for such receipients and
807: -- proceed.
808: IF l_recipient_id IS NOT NULL THEN
809:
810: select pa_dist_list_items_s.nextVal into l_list_item_id from dual;
811:
812: PA_DISTRIBUTION_LISTS_PVT.CREATE_DIST_LIST_ITEM(P_VALIDATE_ONLY => 'F',
813: P_LIST_ITEM_ID => l_list_item_id,
814: P_LIST_ID => l_list_id_to,