APPS.FTE_REGION_ZONE_LOADER dependencies on DUAL

Line 50: SELECT WSH_REGIONS_S.NEXTVAL FROM DUAL;

46:
47: FUNCTION GET_NEXT_REGION_ID RETURN NUMBER IS
48:
49: CURSOR GET_REGION_ID IS
50: SELECT WSH_REGIONS_S.NEXTVAL FROM DUAL;
51: l_region_id NUMBER := -1;
52:
53: BEGIN
54:

Line 441: SELECT WSH_ZONE_REGIONS_S.NEXTVAL FROM DUAL;

437: (p_postal_code_from IS NULL OR postal_code_from = p_postal_code_from) AND
438: (p_postal_code_to IS NULL OR postal_code_to = p_postal_code_to) ;
439:
440: CURSOR GET_NEXT_PARTY_REGION_ID IS
441: SELECT WSH_ZONE_REGIONS_S.NEXTVAL FROM DUAL;
442:
443: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.INSERT_PARTY_REGION';
444:
445: BEGIN

Line 713: FROM DUAL;

709: L_POSTAL_CODE_TO POSTAL_CODE_TO_TAB;
710:
711: CURSOR GET_INTERFACE_REGION_ID IS
712: SELECT WSH_REGIONS_INTERFACE_S.NEXTVAL
713: FROM DUAL;
714:
715: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_REGION';
716:
717: BEGIN