APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on DUAL

Line 544: FROM DUAL;

540:
541: */
542: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL
543: INTO x_pick_slip_number
544: FROM DUAL;
545:
546: g_pskey_table(l_hash_value) := l_Insert_key_Rec;
547: g_pskey_table(l_hash_value).counter := 1;
548: g_pskey_table(l_hash_value).pick_slip_number := x_pick_slip_number;

Line 872: FROM DUAL;

868: as we want to generate a new one for each line
869: */
870: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL
871: INTO x_pick_slip_number
872: FROM DUAL;
873:
874: x_api_status := FND_API.G_RET_STS_SUCCESS;
875: RETURN;
876: END IF;

Line 913: FROM DUAL;

909: as we want to generate a new one for each line
910: */
911: SELECT WSH_PICK_SLIP_NUMBERS_S.NEXTVAL
912: INTO x_pick_slip_number
913: FROM DUAL;
914: ELSE
915: -- Insert new key to table based on grouping rule
916:
917: Create_Hash(p_rule_index => l_rule_index,