APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on DUAL

Line 545: FROM DUAL;

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

Line 873: FROM DUAL;

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

Line 914: FROM DUAL;

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